Pivot with different total

[Morrison]

Hi,

I created a pivot table with sales MTD YOY%, in the dimensions I entered the Year-Month but in the column total the result of the last column is replicated, that is the month of September. On the graph I have inserted the current year as a date filter. Is it possible to see the YTD YOY% value instead of the replicated data? Thank you 

Sales Net Amount MTD YoY%
RM	2022-01	2022-02	2022-03	2022-04	2022-05	2022-06	2022-07	2022-08	2022-09	Total
A	xx	xx	xx	xx	xx	xx	3,00%	2,00%	3,00%	3,00%
B	xx	xx	xx	xx	xx	xx	1,00%	1,30%	4,00%	4,00%
C	xx	xx	xx	xx	xx	xx	1,50%	1,70%	1,90%	1,90%
Total	xx	xx	xx	xx	xx	xx	1,83%	1,67%	2,97%	2,97%

[amitchandak · Accepted solution]

@Morrison , You can use is isfiltered or isinscope to switch the grand total measure

if(isinscope ([Month Year]), [Meausre], [YOY Meausre])

HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[Morrison]

@amitchandak thx for the solution 🙂