Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw.
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
Kind of. I added an expression =1 and removed it again after pivoting.
I thought so.