Convert pivot table total to field to a calculated field and add filter to grand total column
I am building a pivot table and trying to do the following:
1. I would like to add a filter option to the TOTAL column.
2. I would like to build charts off the TOTAL column (e.g. I want to create a stacked bara chart with values from the TOTAL column). Is there any way to do this? Can I convert the TOTAL column into a data field or a calculated field so that I can use that column to build additional charts?
I'm very new to QlikSense and am not sure how to export and attach the model to this question (I'm using the web version) so I took a screenshot. Any help anyone can offer is appreciated!
