How can i get a specific value from a dynamic table to all lines?

[#1]

How can i get a specific value from a dynamic table to all lines?

I have a dynamic table, but i need a NET SALES value to use in all lines in the second column, anyone have some idea about it???

I try to use set analysis and aggr.....but without results!!!!!!

tks a lot!!!!!

[#2]

Do you want 123,00 to appear on every row of the NET SALES column? If so, I think you need to add the TOTAL modifier to your expression. What is the expression for NET SALES? If it is something like Sum(NETSALES), then use:

Sum(TOTAL NETSALES)

The TOTAL modifier ignores dimension when calculating the expression.

[#3]

I solve this problem with...

=sum({$<Grupo={'NET SALES'}>} TOTAL Value)

tks Miller!!!!

[#4]

Thanks for your reply. It partially solved my problem. However, If I add a time scale say "Period" which is in 'MM YYYY' format in the pivot table and then do an aggregation function like this:

=aggr(no distinct sum({$<Grupo={'NET SALES'}>} TOTAL Value), Period)

I am unable to get the aggregated value for every Period.

Please suggest.

Regards,

Vineet Agarwal

[#5]

Ypu can try ?

=aggr(no distinct sum(TOTAL Value), Period)

OR just

SUM(TOTAL Value)

is it works?

[#6]

No. It has to be an aggr function coupled with SET analysis. The reason is 'NET SALES' value should be copied to Total Fields. The expression works well when I have only one dimension. But when I have two or more dimensions, it is taking the sum of Total for the column. It should take total only upto that month and then change for next month.

With Regards,

Vineet Agarwal