Pivot Table Total with Filters

Hi. I would like to plot a pivot table which plots the following dimensions and value, as below:

I have setup my pivot table with the following fields:

  • ROWS:
    • user
    • status
    • value 1
    • value 2

If I create the Total using the Total - Columns feature, it will total up all the statuses (status 1 + status 2 + status 3).

Is there a way for me to get the total based on certain filtering? I would like for the total to only display the total of status 1 + status 2.

Thanks! :slight_smile:

Hi @sabmz
dont think thats possible.
But you could create a calcualated total.

1 Like

Thanks @ErikG. If I were to create a calculated total, is there a way for me to include it in the same table?

Or would I need a separate visual/ table to display this?

1 Like

Easiest way would be a second visual.
But I will think about if it’s possibly in a nice way.

1 Like

Hi @sabmz
could you find a solution?

Hello @sabmz, since we have not heard back from you, I will archive this topic. If you still need assistance with this issue, please post a new question in the community and link this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!