Hello,

I am trying to use the new P&L Pivot table function in Qlik Sense.

It works great except that I would like to create a style format template and I can't manage to do what I want.

How am I suppose to create the subtotals?
For instance, I've got the following account in my data:

Sales A
Sales B
Sales C

I would like my table to look like this:

Sales (which is just a title)
             Sales A
             Sales B
             Sales C
    Total Sales

Thus, How is Qlik Going to understand that it must link my 3 sales accounts to the sales titles, the sales subtotals and also understand that total sales is the sum of sales A+B+C?

Thank you for your help.