I want to calculate sum(value) based on months(last 3 months) and Category.
So i used set analysis in expression. It works fine.
But zero vales are not visible in bar chart.
If the current month is March. Then Bar chart has to show Jan, Feb and Mar as month.
I dont have data for feb month, but has to show sum(value) as 0(Zero).
It is showing only Jan and Mar month.
Please help me on this.
Thanks in Advance...
Thanks for your reply.
I checked script..
While posting question, I forgot to add one more field in script and expression.
So again i attached excel and .qvw
please look into that.