Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have finance report i want to create manual row in the same reports example:
i have
Sales
Cost of sales
Gross Profit = Total , all these data from data source just i need to add one more row for
Gross Profit % Sales -
Group | Value | Group % Sales |
---|---|---|
Sales | 100 | 100 %100 |
Cost Of Sales | 50 | 50 %100 |
Gross Profit(Sales+ CoS | 150 | 150 % 100 |
Gross Profit % Sales | 150/100 | (150/100) % 100 |
Please help me to create this format.
The best way to do this for financial reports is to use a straight table not a pivot table.
Have a look at this thread for more details. http://community.qlik.com/docs/DOC-3324