Forum Discussion
Helper IPivot with different total
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% |
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/
2 Replies
- amitchandak
Super User
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/
Morrisonamitchandak thx for the solution 🙂