15 votes6 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
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?
Ashvini Sharma [Microsoft Excel]
70 votes17 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Thanks for opening this item, looking forward to getting more votes from the community to boost the priority of getting this done.
ash [MS XL]
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..
While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?
25 votes24 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Can you provide more information on what you’re looking for? An example would be wonderful.
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?
9 votes5 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
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?
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
9 votes4 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
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.