Forum Discussion

RP101's avatar
RP101
Frequent Visitor
1 year ago

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...
Need Help
RP101's avatar
RP101
Frequent Visitor
1 year ago

Hi danextian 

 

Thanks for the quick reply ! I will check and see if it helps. how were you able to upload pibx files I was trying wanted to upload mine but didn't see any options. 

 

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Only superusers, CST and community admins can. You may post a link to files stored in the cloud though - just make sure they're publicly accessible/no need to request for permission.

    • RP101's avatar
      RP101
      Frequent Visitor
      1 year ago

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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.