S
Sanj
Is there a way to get variance in pivot table?? I want to
display my data as normal and get variance instead of
grand total. need to create Pivot table as Men/Women as a
page, data which displays pops as month(Jan) and Feb in
Columns and variance in third column. Tried to create
through option and by difference but shows variance in Feb
03 column. any help will be appreciated.Thanks
Month Men/women Country Pops
Jan 03 M XXXX 123
Jan 03 M YYYY 456
Feb 03 W ZZZZ 777
Feb 03 M BBBB 888
Jan 03 M AAAA 999
Feb 03 W CCCC 444
....... .... .... ...
upto 14000 lines
Sanj
display my data as normal and get variance instead of
grand total. need to create Pivot table as Men/Women as a
page, data which displays pops as month(Jan) and Feb in
Columns and variance in third column. Tried to create
through option and by difference but shows variance in Feb
03 column. any help will be appreciated.Thanks
Month Men/women Country Pops
Jan 03 M XXXX 123
Jan 03 M YYYY 456
Feb 03 W ZZZZ 777
Feb 03 M BBBB 888
Jan 03 M AAAA 999
Feb 03 W CCCC 444
....... .... .... ...
upto 14000 lines
Sanj