Pivot Table Total with Filters

Question & Answer
, ,
1

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

image
image1944×240 18 KB

I have setup my pivot table with the following fields:

  • ROWS:
    • user
  • COLUMNS:
    • status
  • VALUES:
    • 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:

2

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

1 Like
3

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
4

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

1 Like
5

Hi @sabmz
could you find a solution?
BR

6

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!