Discussion board where members can get started with QlikView.
I have more than 100,000 lines showing invoice data. Few lines are shown below.
I want table as below
Kindly help me.
Go to Solution.
1 - sum(PurchaseAmount) / sum(SoldAmount)
([Sold amount]-[Purchase Amount])/[Sold Amount]
Go to Number Tab:
Select Fixed to: 2 Dec
Tick on checkbox "Show in %age"
This is already done and I am getting TOTAL for "Purchase Amount" and "SOLD AMOUNT" but not getting total for % PROFIT.
I think Erika giving the correct answer, if not that is exactly, what you want?
A little more information would be good.
I want total at bottom for Purchase Amount, Sold Amount & % Profit.....
If you are using a pivot table, you need to go to presentation tab and click show partial summaries for the top dimension, or change the table to a straight table
if u r using Pivot table:
Thanks for your response. Sorry but I am not getting TOTAL by using PIVOT TABLE for % Profit
See the attached sample for clearity
And suntotal of Purchase Amount, Sold Amount & % Profit.....
By the help of straight table you get this in pivot it is not possible for the expression, there you do only on dimensions.
Can u upload ur Sample App.