Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data whereas on few dates transactions are not there. I want to show table with zero values where data is missing.
I can able to show them using simple join with calendar. However i have to create different charts using set analysis but i cannot able to show date with zero values.
I believe there is small change required in set analysis. But i can not able to get. Please find the attached qvw and excel data to understand more.
Please help me to achieve this. Thanks.
Sridhar
May be this:
Sum({<Type={'A'}>}Amount) + Avg({1<Month = p(Month)>} 0)
Thanks Sunny, giving correct results. However i am not aware how it works "+ Avg({1<Month = p(Month)>} 0)"
and any drawback using this?
Don't think there are any drawbacks. Have you found any? I might not be aware of all the selections you might be planning to make, so can't really say
Yes, you are true.. i will make selection boxes fields duplicate to avoid confusion for user.
Thanks sunny. I will analyze how is working to get this result.