Hi All,
I'm currently having problems seperating total values on my pivot chart.
| Month | Segment | Amt |
| Oct | | 20788814.93 |
| Oct | A | 20788814.93 |
| Oct | B | 20788814.93 |
| Oct | C | 20788814.93 |
| Oct | D | 20788814.93 |
| Oct | E | 20788814.93 |
| Oct | F | 20788814.93 |
| Oct | - | 20788814.93 |
| Month | Segment | Amt |
| Nov | | 19838230.06 |
| Nov | A | 19838230.06 |
| Nov | B | 19838230.06 |
| Nov | C | 19838230.06 |
| Nov | D | 19838230.06 |
| Nov | E | 19838230.06 |
| Nov | F | 19838230.06 |
| Nov | - | 19838230.06 |
|
|
|
Now, When I select both MONTH.
| Month | Segment | Amt |
| Oct |
| 40627044.99 |
| Oct | A | 40627044.99 |
| Oct | B | 40627044.99 |
| Oct | C | 40627044.99 |
| Oct | D | 40627044.99 |
| Oct | E | 40627044.99 |
| Oct | F | 40627044.99 |
| Oct | - | 40627044.99 |
| Nov |
| 40627044.99 |
| Nov | A | 40627044.99 |
| Nov | B | 40627044.99 |
| Nov | C | 40627044.99 |
| Nov | D | 40627044.99 |
| Nov | E | 40627044.99 |
| Nov | F | 40627044.99 |
| Nov | - | 40627044.99 |
It totals up Oct & Nov. IS there any way I can seperate the values?
I am using the total in the expression
Thanks
