Exclude Dimension..

[vijayit43]

Hi,

In My QV is Dimension Field State & Brand and Expression field is Count(Retailercode) brands is Three Type A,B,C when Brand Dimension A then count B and C Brand Retailercode,when Brand Dimension B then count C and A Brand Retailercode when Brand Dimension C then count A and B Brand Retailercode How to Achieve It

Please Suggest

[#2]

Hi,

You can create a second brand field with the needed associations with the first brand.

For example:

Brands2:

Load * inline [

Brand2, Brand

A, B

A, C

B, A

B, C

C, A

C, B

];

This table will be linked to Brands table through field Brand.

In your chart, you can still use your current expression count(retailercode) and as dimension Brand2.

Hope this helps.

[vijayit43]

we dont change Brand in dimension because 5 other column in expression..