Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to set Jun-2010 forecast value for all Months. I have pivot table with only one dimension - MonthYear. If I use set analysis formula
sum ({$<MonthYear= {'Jul-2010'} >} Forecast))
my table shrinks to only one row for Jul-2010. I would rather expect all 12 months with one Forecast value (for Jul-2010). Help please.
Micha?
Could you give some more info on your data structure? The results you describe are the results I would expect from that expression. Sum of Forecast for only Jul-2010. With Month-Year as dimension, that's one line for Jul-2010 only.
Do you have multiple date fields in your data set? You say 12 months with Forecast date of Jul-2010. What is Forecast date and where do the 12 months come in in relation to the single Forecast month.
Do you want to see all 12 months in your dataset, but show all the same value? If so, then you may want:
sum ({$<MonthYear= {'Jul-2010'} >} TOTAL Forecast))
Could you give some more info on your data structure? The results you describe are the results I would expect from that expression. Sum of Forecast for only Jul-2010. With Month-Year as dimension, that's one line for Jul-2010 only.
Do you have multiple date fields in your data set? You say 12 months with Forecast date of Jul-2010. What is Forecast date and where do the 12 months come in in relation to the single Forecast month.
Do you want to see all 12 months in your dataset, but show all the same value? If so, then you may want:
sum ({$<MonthYear= {'Jul-2010'} >} TOTAL Forecast))
Wow, works perfectly. Many thanks.