I have the below data (sorry I can't convert to html, it says "Error:1004")
Region__ Model__ Revenue
North__ A__ 10
West__ B__ 11
South__ C__ 12
South__ D__ 13
South__ A__ 14
East__ A__ 15
East__ B__ 16
And I created a pivot that looks like this (this one can be coverted to html):
The "Cost" field is a calculated field, with the follwing formula:
So, can somebody tell me why is it returning zero values?
Thanks
Region__ Model__ Revenue
North__ A__ 10
West__ B__ 11
South__ C__ 12
South__ D__ 13
South__ A__ 14
East__ A__ 15
East__ B__ 16
And I created a pivot that looks like this (this one can be coverted to html):
| Book2 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Data | |||||
| 2 | Model | SumofRevenue | SumofCost | |||
| 3 | A | 39 | 0 | |||
| 4 | B | 27 | 0 | |||
| 5 | C | 12 | 0 | |||
| 6 | D | 13 | 0 | |||
| 7 | GrandTotal | 91 | 0 | |||
Sheet2 | ||||||
The "Cost" field is a calculated field, with the follwing formula:
Code:
= IF(Model ="A",Revenue *0.8,IF(Model ="B",Revenue *0.7,IF(Model ="C",Revenue *0.6,IF(Model ="D",Revenue *0.5))))So, can somebody tell me why is it returning zero values?
Thanks
