Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Qlik Sense SaaS pivot table that has Payments and Balance as measures displayed by each month. Is there a way to display only the Total column for “Balance” and not the monthly “Balance” column?
Instead of the below...
Customer Group | Totals | 14-Jan | 14-Feb | |||
Payments | Balance | Payments | Balance | Payments | Balance | |
retail | 3250 | 2500 | 1000 | 2000 | 250 | 500 |
I want it to look like the below...
Customer Group | Totals | 14-Jan | 14-Feb | |
Payments | Balance | Payments | Payments | |
retail | 1250 | 2500 | 1000 | 250 |
Hello @qlikuser2021, could you please share a screenshot of the pivot table? Thanks a lot!
Collections are monthly where facevalue and purchase price are static and only would have values for the month of purchase. I don't want facevalue and purchaseprice to be displayed for each month. I just want them in one column on the left next to the total of the monthly collections.