Pivot Table Assistance

Mon, 08 Apr 2013 11:34:20 GMT

Hi Guys,

I am seeking advice to display a report for Sales vs Forecast.

Here is my scenario:-

Actual Sales is always fixed.
Forecast Sales is dynamic based on the Forecast No.
If i select the Forecast No, the Forecast Sales will always compare with Actual Sales.

Challenges:-

Sample Reports:-

i tried many ways, but the Actual will always change together with my forecast sales.

I hope i can hear from you guys soon, thanks for your help.

Matthew

Re: Pivot Table Assistance

Tue, 09 Apr 2013 06:01:09 GMT

For this scenario, i have created a Logical Calander, Logical Customer table,

so in my pivot table i use Logical Cust Code and Logical Month as dimension

in my express i want to use set analysis with Forecast Cust Code = Logical Cust Code, Forecast Month = Logical Month

Sample script:-

Sum({$<[IFCUS_CUSCD]={"=[IFCUS_CUSCD]=[LOGICAL_CUSCD]"},[IFCUS_MONTH]={"=[IFCUS_MONTH]=[MONTH]"}>}IFCUS_SALES)

But this script doesn't work right, please help!