Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Actual and Planned Sales. Actual is on Date Level and Planned is on Month Level.
But in my Table I want to show Month level Planned Sales repeating to each day.
In the above screen shot. Monthly Planned Sales for 2016 and Month =3 is 1701335.95.
I want this value to be repeating in each Day.
I am attaching my qvw file.
Please help.
Thanks,
Sarif
try sum({<DateTransaction=>}total [Planned Sales])
try sum(total [Planned Sales])
Yes Sir,
It is repeating now. But the problem is If I select any Date, then it is showing different value.
I want this to be fixed for any date selection from THAT PARTICULAR MONTH.
Please help.
Thanks,
Sarif
try sum({<DateTransaction=>}total [Planned Sales])