Is it possible to make the difference of data?

[#1]

Hi,

I have to show the difference of count of IDs

for eg: dimension should be week and Type

the expression should show the difference of todays count of ID and last week count of id

would it be possible? can anyone please suggest me.

Thanks.

[#2]

what I mean is I should show

Week                                     1              2        3     4    Total

Customer                               200         0       23     1       224

Member                                   78         0         3     0        81

Total                                        278        0       26   1     305

[swuehl]

Is this your input data or your requested result? Sorry, I don't understand your example.

In principle, if your dimension is Week and you need to compare an expression for 1 Week to another, you can use chart inter record functions, like above(), below() or before() and after in a pivoted table.

So in your example, if you pivoted dimension Week to the top and Type is a vertical dimension, try something like

=count(ID) - before( count(ID) )

replace count(ID) with your current expression and replace before with above if Week is not pivoted to the top.

See also the HELP for a detailed explanations of the chart inter record functions.