Ranngesum not working in pivot table when only one expression is written

[#1]

Hello Everyone,

When using only one expression in pivot table the data doesn't get displayed. But when second expression is written the chart gets populated.

The requirement is that:

SS	Month	diseng
SS1	june 2013	10
SS1	july 2013	13
SS1	aug 2013	10
ss2	june 2013	1
ss2	july 2013	2
ss2	aug 2013	3

NOw i want to count the cumulative  disengagements for SS. in pivot table.

like For value SS1,for the month of june2013,disengcount=10
and for the same SS1 FOR THE MONTH OF JULY 2013, it should be (13+10)=23.
i want this to be represented in pivot table by transposing the month .

Can anyone help on this?

Regards,

Pratik

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

Hey Gysbert,

Thanks for the reply.

Actually I also tried in the same manner but after giving the expression the chart not used to get populated, because of the before function I guess. Then after giving the additional expression of ColumnNo() the chart got populated and eventually after transposing the additional column was introduced.

So now I transposed first and then gave the expression then it worked.

What was the sequence you followed?

Thanks for your reply.

Cheers!

Pratik

[Gysbert_Wassenaar]

Kind of. I added an expression =1 and removed it again after pivoting.

[#5]

I thought so.