Sorry the title is useless.
I have an accounts download with a lot of items, some debits, some credits, that are improperly hiding each other.
I have a graph based on a table based on a pivot, current out put shown below.
Orginaly, the graph was showing three columns, one of 50m one of 150 and one of 500, which isnt that hepful
I added a Cr/Dr Column, so now I get 6 columns, of -100, 150, -50, 200, 0 and 500
Which although an improvement, isnt really that clear either.
What I want, is a single column stretching from -100 to 150, another from -50 to 200, and a third from 0 to 500.
And if your method can easily replicated for the rest of the age buckets (Current, 0-30, 31-60 ect), I will be very greatful
<TBODY>
</TBODY>
I have an accounts download with a lot of items, some debits, some credits, that are improperly hiding each other.
I have a graph based on a table based on a pivot, current out put shown below.
Orginaly, the graph was showing three columns, one of 50m one of 150 and one of 500, which isnt that hepful
I added a Cr/Dr Column, so now I get 6 columns, of -100, 150, -50, 200, 0 and 500
Which although an improvement, isnt really that clear either.
What I want, is a single column stretching from -100 to 150, another from -50 to 200, and a third from 0 to 500.
And if your method can easily replicated for the rest of the age buckets (Current, 0-30, 31-60 ect), I will be very greatful
Industry | Cr/Dr | Future |
101 | Cr | -100 |
101 | Dr | 150 |
102 | Cr | -50 |
102 | Dr | 200 |
103 | Cr | 0 |
103 | Dr | 500 |
<TBODY>
</TBODY>