Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
4 years ago

Measure before/after calculation in one table

Hello,

 

I am struggling with the client's request. They have cost report with the entries for 3rd party clients and intercompany (other sale branches) together. Now, they want to visualise it in one table as per below:

 

Measure nameTotal Sales including IntercompanyTotal Sales excluding Intercompany
Measure 1200150
Measure 2300280
Measure 3800720

 

Is there any way how to achieve this without duplicating the sales report table or creating 2 separated visuals? If I use Filter panel, it is applicable for both columns in the table.

 

Thank you!

IvanS

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    IvanS , If those are column values, You can use matrix, Show on row, and intercompany flag on the column.

     

    else you need to consider the calculation group

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

     

    • IvanS's avatar
      IvanS
      Icon for Helper V rankHelper V
      4 years ago

      Hi amitchandak ,

       

      those are column values but if I use Intercompany flag as a column, I got following:

       

      Measure NameICONo ICOTotal
      Measure 1   
      Measure 2   

       

      This is not the information I would like to share. What I am intersted in is column "Total" as before applying Intercompany filter and "No ICO" as after applying Intercompany filter and removing Intercompany sales.