Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @sunny_talwar . I have a new problem now. I have given the Customer number, Customer name and the year in the dimension and written the expression =sum({<FISCAL_YEAR={2020}, Customer_Name=e({<FISCAL_YEAR={2019, 2018}>})>}Orders). Please find the below screenshot. This table is showing me the Order value of customers only in the year 2020 but not in 2019 or 2018.
If I select a particular customer, it should show only that one customer's value right? For example, if I select the second customer 'IGET Industre', the table should show me only the order value of that specific customer. Instead, if I select that customer, the table gives me the list of all 2020 customers. If you see the below screenshot, the table is showing Order total value for all the 2020 customers when only one customer is selected. You have any idea why? Can you please help me?
Thanks a lot again @sunny_talwar
@Hariprasath2394 no problem, I am glad I have been able to help