Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gurus,
I am running into an issue where I want to capture the sum of order lines with respect to a calculated date dimension in a graph.
I have made some calculation like currentdate-7 based on selection value in the x-axis against which I want to see the sum of order lines for that date.
Now the issue is I can successfully make the date dimension work i.e when i select a current date from selection the x axis is showing correct result (i.e previous 7th day) but in the y axis its still showing the sum of order lines for the current date.
will really appreciate if someone points me out what wrong I am doing here.
Reagrds,
Aniruddhya
Are you ignoring datefield selection in your expression?
Sum({<DateField =>}Sales)