What if you leave the MONTH date pill on a view
(on Details as you've got on your first screen above),
but change its granularity to be the Quarter instead of Month?
Simply right-click on the pill in Details and change to Quarter
(either Quarter discrete or continuous would suffice, i guess).
I Tried, the data is disappearing when i covert the month date field to quarter, i can see the spit of 3 months data if i could have month in detail... whereas i need the average of quarter data, as i am using current quarter calculation in the filter. I think you understood the issue.
Could you please share the sample workbook ? It would help us understand better how the data sources have been setup.
we have confidential data in it I cannot share, whereas i can explain you the condition here, we have month field in date format, we have 2 months actual's from one source and 1 month forecast from another sources, we have blended both the sources on required fields. Here we need to showcase the data by quarter wise for Q3 i want to shown 2+1 data,
here. I can see the data when i will drop month field in details only that too in month format not in quarter, if i convert that month to quarter, data is disappearing. if i place month it is splitting as shown in my attachment.I think i explained you the situation clearly. if you could help me to solve this i am very thankful.
What does the calculation [billed utilization A + F] look like?
i have derived the calculation for actual as "billed utilization A" from one source and forecast "F" from other source. I have scenario field (Actual and Forecast) in both sources.
I wrote a calculation with scenario.