
Re: Pivot Table partial sum problem
Robert Mika Sep 7, 2015 12:40 AM (in response to Sara Khalili)Division comes before subtraction so try like this:
(Sum(Sales)Sum(SalsPlan))/Sum (SalesPlan)

Re: Pivot Table partial sum problem
Harshitha Harshu Sep 7, 2015 12:50 AM (in response to Sara Khalili)Hi,
Try (Sum(Sales),Sum(SalesPlan),(Sum(Sales)Sum(SalsPlan))/Sum(SalesPlan))

Re: Pivot Table partial sum problem
Harshitha Harshu Sep 7, 2015 12:53 AM (in response to Sara Khalili) 
Re: Pivot Table partial sum problem
Jonathan Dienst Sep 7, 2015 1:35 AM (in response to Sara Khalili)In addition to the suggestions above, you may want to achieve a sum of rows calculation, To do this in a pivot table:
Sum(Aggr((Sum(Sales)Sum(SalesPlan))/Sum (SalesPlan), <chartortabledimensions>))
Where <chartortabledimensions> is a commaseparated list of the dimensions in your chart or table. For example
Sum(Aggr((Sum(Sales)Sum(SalesPlan))/Sum (SalesPlan), FinishedGoods, Year, MonthName))
This is because the partial sum performs the expression on the total amounts, and "the sum of the ratios is not the same as the ratio of the sums"

Re: Pivot Table partial sum problem
Sara Khalili Sep 7, 2015 5:56 AM (in response to Jonathan Dienst )Hi,
Thanks a lot. your solution works and my problem is solve.

Re: Pivot Table partial sum problem
Michael Tarallo Sep 8, 2015 8:26 AM (in response to Sara Khalili)Hi Sara,
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik

Re: Pivot Table partial sum problem
Sara Khalili Sep 9, 2015 12:18 AM (in response to Michael Tarallo )Hi Mike ,
for your kind information the solution was correct

Re: Pivot Table partial sum problem
Michael Tarallo Sep 9, 2015 12:29 PM (in response to Sara Khalili)Hi Sara  just to be clear  I am asking you to mark which reply in this thread, was correct in regards to the solution you used for your original issue.
You can see an example here: Qlik Sense Community Forum Tour  Welcome  YouTube  Mark Correct / Helpful
Regards,
Mike T
Qlik



