Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can ignore the selection using the set analysis, something like below.
Sum({<Delivery_Date=>}TotalOrders)
Regards,
Kaushik Solanki
Don't create double posts for single issue
Allow only one dimension to select