Ashvini Sharma (Lead Program Manager, Microsoft)
My feedback
-
15 votes6 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
265 votes24 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.
An error occurred while saving the comment hi aikimark1955, it's just a matter of prioritizing what we work on, so getting votes on this item is actually helping us weigh the importance vs. other items..
An error occurred while saving the comment While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?
-
63 votes33 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Updating the status of this item to Accepting Votes. Note that this can be accomplished using Power Query, but the result is a table rather than a PivotTable.
An error occurred while saving the comment I received a response back from Sam on this that's more looking for supporting Text measures that propogate, where there's only one value for each value in the pivot table. Is this what others are looking for as well?
thx
ash -
9 votes5 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Hi Levi,
Thanks for the response. Since you're familiar with the Table viewer in Power Pivot, wondering how the functionality of the "database" sheet type would be different than that capability. I.e. is the request a matter of hosting that experience as a new sheet tab in Excel? Or would that still be too much?
thanks
ashAn error occurred while saving the comment Hi Bill,
Have you looked at the 'Data Model' and Power Pivot capability of Excel 2013 and later? It's designed to scale to much larger datasets than the grid, and support joins, calculated columns & measures..
Would love to hear of your experience with it
thanks
ash -
14 votes5 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Sanjib, Data Model in Excel 2013 and beyond is designed to support large number of rows. Have you already tried it out and found it lacking? How so? I'm curious what your scenario is where the number of columns is restricting.
'
Hi Roman,
I'm having trouble understanding this idea clearly to see whether Kenneth's input (which seem like the best solutions) are overkill or not. Seems like you have a range of cells where several columns together identify a unique product and you want to be able to operate on them as a group - change fonts/colors/summarize, etc.?
Is it possible for you to describe in more details?
thanks
ash
Ashvini Sharma [Microsoft Excel]