Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a pivot table with year quarter and month i have computed total profit for monthwise and i need to show the total of all the three month value in last column.
I have attached the qvw please check
Hi techvarnun,
I've worked with your qvw, the result is that you must add the following expression (After Total):
aggr(NODISTINCT Sum({<Category={'Revenue'}>} [Exchange Rate]*[Total (Amount)]) - Sum({<Category={'Costs'}>} [Exchange Rate]*[Total (Amount)]) ,Category, Type, Year, Quarter)
This expression add a new column where all rows have total of quarter, if you need only one row with the total (but not a new row) delete NODISTINCT
Hope it helps
see the attachment
Sorry am on my qlikview personal edition
Regards
IS that u want u want to add app+may+june and it should display in the next row
in presenttion enable show partical sums to month