Stright Table Sum of inter records

[#1]

Hi All,

I am trying to get  a table like below in the Qlikview , for this I have used expression like this  RangeSum(above(Column(2)*column(3),1,aggr(Count(DISTINCT Dimention),Dimention_Group), however I didn't get the desired result, ca any one help me on this.

Column1	Column2	Column3
column(2)*column(3)=6	2	3
column(2)*column(3)=20	4	5
column(2)*column(3)=42	6	7
Sum(above three rows)=68	12	15
column(2)*column(3)=15	3	5
column(2)*column(3)=24	4	6
Sum(above 2 rows)=39	7	11
column(2)*column(3)
column(2)*column(3)
column(2)*column(3)
Sum(above 3 rows)

Regards

John

[Kushal_Chawda]

In pivot table you can achieve this . Go to Presentation tab of Pivot table and check the Partial sum option for desired dimension

[Kushal_Chawda]

See the attached.

This is what you are looking for?

[#4]

Thanks Kush141087 , Your Application is working fine, however my requirement was different, what I need, the same output that you are getting in the demo app in Pivot, I am expecting it in the Straight table, why because I don't want to show the Group details.

Best Regards

John

[#5 · Accepted solution]

Got It. I have used only expression as Columan(2)*column(3)  it has worked Perfectly.