Forum Discussion

qazz12's avatar
qazz12
New Member
2 years ago
Solved

Comparing two tables vertically and display the difference

I have two datasets, one with projected numbers and one with actual numbers. The team requested for a dashboard to be built to compare the two but stacked vertically and with the differences displaye...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi qazz12 
    You can achieve this layout using disconnected table of all variations of 
    Categories + projection and actual and dynamic measure. 
    The logic is very similar to p&l statements.
    For more information please refer to the linked tutorial:
    https://www.youtube.com/watch?v=SH4UX4fGU9A&t=1226s

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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi qazz12 
You can achieve this layout using disconnected table of all variations of 
Categories + projection and actual and dynamic measure. 
The logic is very similar to p&l statements.
For more information please refer to the linked tutorial:
https://www.youtube.com/watch?v=SH4UX4fGU9A&t=1226s

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