How to fix the data issue for fiscal years & fiscal quarters

[Lakshmikanth_Boddu]

Hi,

I want to fix the data issue respective of the filter selection. Here I have filters like LocationId & Fiscal Quarter & Fiscal Year. And I have a chart which contains the two different tables data. Whenever I select the LocationID & Fiscal year, the data is showing same for all 4 quarters in a fiscal year. If I am not selecting any LocationID filter, then the value is showing as expected for all 4 quarters. 

1. The graph should be updated based on the Quarter or Year.

2. When I select Fiscal year, we are seeing the values per quarters are all the same but which is not correct.

3. One Quarter has more other has less.

And we are using the expression as below.

Sum({$*MDF<Auto_MDF_Month={$(vCalMonth)},S------------ ={'----'},[Location ID]=>} Totalamount)/1000

We need exactly the open per Quarter pipeline value, the own per quarter opties values.

Please help me to get the resolution for this.

@sunny_talwar