Pivot table roll-up from a floating table

Ask a Question

Hi Qlikers!

I have two floating tables which I am using for an income statement made from an Inline table load,

ISSUB:
Load * Inline [
Sort, IS
1, Gross Profit
];

ISSUB:
Load * Inline [
IS, ISSUB
Gross Profit, Revenue
Gross Profit, Cost
];

So these are not linked to my fact table and isolated floating table. I am using a pivot table

if(IS='Syntell GP',sum(PERCENTAGE AMOUNT])-sum(Fee),
if(ISSUB='Syntell Revenue',sum([PERCENTAGE AMOUNT]),
if(ISSUB='Syntell Cost',sum(Fee)
,0)))

Whereas Ideally I should be getting 3 different individual numbers i.e Gross Profit 20, Revenue 100, and Cost 80 for example.

Any idea how to achieve this?

0 Replies