Last 6 Months Formula with Multiple Dimensions Like Zone, Region, Branch

[nayanpatel]

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

[lironbaram]

hi 

have a look at the QVF

all you needed to do is to change the order of the aggr dimensions 

[nayanpatel]

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

[lironbaram · Accepted solution]

hi 

do in the chart properties , 

in add-on section , uncheck the display zero values