Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I need data to be displayed in Bar chart with Last 6 months data to be carry forwarded and also output should be with multiple dimensions like Zone and Region etc.
I have attached Data file and QVF
1. Data file contain data + Expected out put sheets.
2. Expected output_1 is good. I need Expected output_2 and _3.
3. Formula calculation given in Data file.
Thank you.
Kindly help
hi
do in the chart properties ,
in add-on section , uncheck the display zero values
hi
have a look at the QVF
all you needed to do is to change the order of the aggr dimensions
Hi Lironbaram,
Thank you for response. It worked. However, the issue is: When I am selecting Zone like East or West, then rest Zones shows Zero.
Attached Screenshot
hi
do in the chart properties ,
in add-on section , uncheck the display zero values