topic Re: Last 6 Months Formula with Multiple Dimensions Like Zone, Region, Branch in App Development

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

nayanpatel — Mon, 20 Dec 2021 21:32:42 GMT

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

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

lironbaram — Sat, 04 Apr 2020 20:13:01 GMT

have a look at the QVF

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

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

nayanpatel — Sun, 05 Apr 2020 08:37:39 GMT

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

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

lironbaram — Sun, 05 Apr 2020 10:38:17 GMT

do in the chart properties ,

in add-on section , uncheck the display zero values