Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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
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.
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
omg, its so simple! i almost killing myself...
Thank you so much