Exclude dimension if no value exist

[gauthamchilled]

hi

i have the sample file attached and explained my issue...

can anyone help???

Thanks

Gautham

[Anonymous]

Hi,

This is what you are searching?

Sum({<Year={'FY2016'},Country=p({<Year={'MY2015'}>}Country)>}Sales)

Best regards,

Cosmina

[Anonymous]

or with variable on selected field:

Sum({<Year={'FY2016'},Country=p({<Year={'$(Variable1)'}>}Country)>}Sales), where Variable1 is =right(GetCurrentSelections(Year),len(GetCurrentSelections(Year))-6)

[rido1421]

Hi There

Select properties>Dimension Limits>Show only values that are greater than:>  enter 0 and exact amount on the drop down.

[rido1421]

Attached QVW