Forum Discussion
YoY Variance Report by Month with dynamic header
Hi, I have created a Year-over-Year (YoY) variance report by month and would like to enhance it with the following features: Add a dynamic header when a year is selected. I tried creating dynam...
Hi danextian
It did not slove my problem completly as I am not getting the column built in grand total. I didn't except that to be not working.
do you have any idea?
thanks
Hi RP101 ,
You could check the DAX formula used for the dynamic headers and ensure it is designed to aggregate correctly at the grand total level. Additionally, consider using the HASONEVALUE function to conditionally calculate totals when all values are present.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.