Different calculation for subtotals - DAX trick for Excel Power Pivot
18.2 هزار بار بازدید -
4 سال پیش
-
#DAX
#DAX #TOPN #PowerPivot #DifferentOutput4Subtotals
Excel Pivot Table subtotals are great for seeing grouped up results. What if you want to see a different outcome for subtotal - for example, the best salesperson's name in each month instead of total sales?
You can use DAX to calculate a different value when looking at subtotal level.
Get the sample file from - https://chandoo.org/wp/wp-content/upl...
Excel Pivot Table subtotals are great for seeing grouped up results. What if you want to see a different outcome for subtotal - for example, the best salesperson's name in each month instead of total sales?
You can use DAX to calculate a different value when looking at subtotal level.
Get the sample file from - https://chandoo.org/wp/wp-content/upl...
4 سال پیش
در تاریخ 1398/12/12 منتشر شده
است.
18,257
بـار بازدید شده