AGGR & SUM

[#1]

Hi,

I have a table with 2 dimensions > Customer & Product.

then i have one expression >>> if(sum(sales_last_month)=0,sum(sales_this_month))/1000

I'm trying to create a Text object to do the above but the result is not quite right.

=sum(aggr( if(sum(sales_last_month)=0, sales_this_month) , Customer ,Product))/1000

any ideas?
Thanks.

[deepakk]

hi,

As per my understanding of Textobject, The textobject cant store array of value. Hence for your condition to work you have to select a Customer as well as Proudct.

I hope this helps.

[#3]

Hi Deepak ,

Thanks for the advice.

How about a table with no dimension. and we do everything in the expression? is it possible?

[deepakk]

Hi,

In Pivot table it will show the value, but it will show the entire value.