Allow only one dimension to select

[sunil1989]

Hi ,

Thanks in advance!!!!

I am having straigh table on my sheet and the column are

Dimension : Delivery date , location.

Expression :Total Orders,WOW Orders , Average Basket.

whenever any date selected on delivery date it should ignore the selected date , but it should select the location , the location which is selected.

Thanks,

Sunilkumar

[Anil_Babu_Samineni]

May be ignore the selections like

Sum({<[Delivery Date]>} [Total Orders]) //Same for all expression may be

[sunil1989]

Hi Anil ,

Apology for dual post.

but my dimension has calculated dimension i.e Delivery Date(WEEKDAY(DeliveryDate) &'  ' & Date(DeliveryDate,'DD-MM-YYYY')).

[avinashelite]

Since the calculated dimension is based on the delivery Date the above logic should work

include {<[Delivery Date]>} set analysis in all the expression