Forum Discussion

ap12's avatar
ap12
Frequent Visitor
4 years ago

YoY with Date Table

Hello,

 

I'm sure this is might be a simple thing but I can't seem to figure it out.

Looking to get the YoY change of number that can be displayed for different grouping (Region & Client Type). I have a date table so it's not easy as using the quick measure creation.

 

Total

Region20212022YoY #YoY %
ASIA5000075000  
Consulting2500030000  
Corporate2000018000  
Institutional500027000  

 

Total - Product #1

Region20212022YoY #YoY %
ASIA50007500  
Consulting25003000  
Corporate20001800  
Institutional500270  

 

Total - Product #2

Region20212022YoY #YoY %
ASIA4500075000  
Consulting2000032000  
Corporate1500020000  
Institutional500015500  

Any help would be great and thank you.

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ap12 ,

     

    Is that a matrix visual you provided? Then there is a drill down hierarchy, which is region & client type, right?

    For example,

     

    If possible, please provide the initial sample data and expected results.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.