Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps create one island table with
Load * Inline [
Dim
1
2
];
And then, create table using
CrossTable(Data, Sales, 1)
Load * Inline [
Data, Sales A, Sales B, Sales C
.............
];
Dimension : Pick(Dim, Sales, 'Total Sales')
Expression : Pick(Dim, Sum(Data), Sum(Sales))
Hello all,
I found a work around but since I can only have one dimension, I have to create my total within the script.
However, by doing that, I cannot play with filters.
Anyone has an idea?
Thank you.