Cross table calculation

[Richard Pobi]

In a cross table I have sum(Actuals), sum(Forecast) and third value column, what I need is whenIf((Sum([Actaul]) + 5)>Sum([Forecast]),1,0) it is working fine, but I want to show it for only EastCoat. The WestCoast should show null or blank.

id, Region,Sum(Actaul),Sum(Forecast), If((Sum([Actaul]) + 5)>Sum([Forecast]),1,0)

1, EastCoast, 10, 7, 1

2, EastCoast, 20, 10, 1

3, EastCoast, 5, 15, 0

4, EastCoast, 10, 10, 1

5, EastCoast, 10, 20, 0

6, EastCoast, 12,8, 1

7, WestCoast, 8, 12,

8, WestCoast, 15, 5,

9, WestCoast, 20, 20,

Attached is the dxp file

Thanks.

[Shashank Gurnalkar]

Hello, I added the following expression and its working for me:

 

If(First([Region])="EastCoast",If((Sum([Actaul]) + 5)>Sum([Forecast]),1,0),NULL)

 

Please refer to the attached analysis file.

[Richard Pobi]

It work, thank you - Shashank