Forum Discussion

Manesh_13's avatar
Manesh_13
Frequent Visitor
2 years ago

Calculation Groups

Greetings All, 

 

I am having an issue at the moment with the display I am getting with calculated groups I want the display to group the output by the measure rather than the Date functions (Current, PY, var Prior Year and % var prior year).
this is what it is currently giving me:

however I want it to display all the sales for Current, PY, var PY and % var PY together and then sentty and then orderqty does anyone know if that can be done and if so how can it be done? 

 

Thanks 

Manesh 

Need Help

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Hi, you cannot get the view you would like directly, however you can create new single measures using your calc group within the filter of a calculate, this will allow you to drop your measures where you like.

    E.g..

    - CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "Current"))

    - CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "PY"))

    - CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "Var Prior Year"))

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Manesh_13 

     

    Can you provide some sample data? And the output you expect. It can be displayed as a picture or in Excel.

     

    Best Regards,

    Community Support Team _Charlotte

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

     

     

    • Manesh_13's avatar
      Manesh_13
      Frequent Visitor
      2 years ago

      Hi, 

       

      This is how I want it to look like:

      so that each metric is grouped together with its respective Current, PY, var to PY, %Var to PY values.