Are shoes and socks literally 2 separate dimensions or are they 2 members of a single dimension? Can you attach some sample data? It is always better to attach sample data or a packaged workbook along with what you expect to see out of the data so someone can easily help out!
Always struggle to find sample cos my data is quite complex haha but thanks! I have the superstore samples attached here.
So I have 2 bar charts of store 1 and 2 (consider them a string season dimension) and the sales.
I need a third chart (or number etc) below showing the difference
Sales Difference Question.twbx 18.6 KB
One more question pooja. I used scaffold to ensure fields are still present despite the fact that data is not there.
LOOKUP(ZN(SUM([AAF Net Amt (USD)])),0)
I used this function. It shows me 0 for I guess fields that have 0 for the underlying data. But certain fields get hidden because there data I think is null. Is there a formula for me to make sure both 0 and null shows as 0
can ignore my latest query, I figured it out
Can you explain the procedure how you sorted out the issue??