Set Analysis

[#1]

Hello guys,

I have this table:

The column "PROD 5" is dynamic , this aways shows the avg of selected product and then compare with de avg of product and market in the dimension. But I have to show the avg of selected product in the markets of column "MKT".

How can I do it?

I tried to compare in set analysis something like this:

Avg(TOTAL {<PRODUCT={'$(=Only(PRODUCTCOMP))'}, MAKET={$(=Only(MAKET))}>} [SACAS/HÁ])

or

Avg(TOTAL {<PRODUCT={'$(=Only(PRODUCTCOMP))'}, MAKET={$(=Column(1))}>} [SACAS/HÁ]) (using only(MARKET) of column 1)

but isnt work...

[beck_bakytbek]

Hi Cintia,

try to use Resident Load; where you can use: PROD 5 / 5 , where 5 is avg of products in MKT

i hope this can help you

with kind regards

Beck

[#3]

it isnt work because the PROD 5 is dynamic selected in a list box. Sorry it was not clear. this is a pivot table, i have a prod. selected in a list box and then compare with others products in the same MKT.

look the qvw file.

[ramoncova06 · Accepted solution]

Have you tried using the field you want to group by ?

something like Avg(total <Product> Sales)

sorry I am not sure I am getting what you need, can you add an example of the expected output

[#5]

omg, its so simple! i almost killing myself...

Thank you so much