How to see detailed Totals when you have two dimension on rows

Jordi Vilamajo
Jordi Vilamajo Customer
10 Comments Level 200: Building A Planning Solution in Board Name Dropper First Anniversary
in Platform

Hi,

We have a Dataview where we have two entities on rows: Region and RL, like follows:

image.png

The Total row adds all the rows, which is OK for the region but has no sense for the RLs.

Is there a way that I could have the Total region detailed by RL?

Thanks

Tagged:

Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    Hi @Jordi Vilamajo ,

    Have you considered using the Drill-down on the total to get the detailed view by RLs?

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi @Jordi Vilamajo ,

    when you use flatten view the Subtotals are not displayed. If you want to see the subtotals, please disable the flatten view.

    Regards

    Björn

  • Jordi Vilamajo
    Jordi Vilamajo Customer
    10 Comments Level 200: Building A Planning Solution in Board Name Dropper First Anniversary

    Hi thanks both for your answer.

    I would discard the drill down because totals should be more direct and visible for the user.

    I have disabled the flatten view but I must still be missing something as I still don't see the RLs of the Totals:

    image.png

Categories