I needed to be able to create a pivot total Vertical.

[urbanfaces]

I have created a custom pivot and I would like to get a grand total for only the metrics call CS. Also, I would like to about to create a subcategory for Column Cat.

[Chip_Matejowsky]

Hi @urbanfaces,

Have you reviewed the Qlik Help entry for Pivot Table?

Also, it seems your question has been asked previously in the past:
https://community.qlik.com/t5/QlikView-App-Dev/How-to-display-data-horizontally-for-a-dimension-in-p...
https://community.qlik.com/t5/QlikView-App-Dev/Pivot-table-field-moving-to-horizontal-position/td-p/...

Best Regards

[urbanfaces]

Thank you, Chip. I read it, but it did not address my desire. I am looking for grand totals and Sub grand totals for the horizontal metrics.
I am Not looking for the data. The data are already horizontal. I just want Grand Totals and Sub Totals.

[Kushal_Chawda]

@urbanfaces  How you have created custom pivot table and how exactly total should be represented? Could you create required pivot in excel to understand?

[urbanfaces · Accepted solution]

I am fine. I just active the Show Totals, and it works perfectly