Dimension Filter based on selection?

[rohitians]

Hello Everyone,

The report is a simple sales report where industry sales is compared to individual sales of a company,

all companies have common SUPERGROUP  but they may be present in different SUBGROUP,

but i want to display comparison of only those SUBGROUPS where in the individual company is present vs the industry for the same SUBGROUP,

kindly help.

In the below pic i just wanna show the subgroups highlighted in red and not all..

[#2]

Hi Yadav,

i am not getting your requirement,Can you explain a bit more.

if possible post one sample QVW.

Thanks,    

Chiru

[#3]

use wildmatch function with if condition

like

if(wildmatch(SUBGROUP,'TOTAL'),SUBGROUP)

[#4]

or you can limit your subgroup from Back End by your condition to the Subgroup which are present in the Individual Company using if or where condition.

For more clarification post your sample application