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)))
![ElPantera_0-1614950930563.png ElPantera_0-1614950930563.png](https://community.qlik.com/t5/image/serverpage/image-id/50518iA80AAAEA68332A3C/image-dimensions/744x75?v=v2)
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?