hi,

my pivot table is ready and working fine, something like this:

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100
200 300

i want something like this:

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100 Dr
200 300

OR

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100 Cr
200 300

i dont think using a calculated field would work ? can this be done ?

regards,
shripal dalal.

You could apply a Custom Format to the cells...
?" Cr" would result in 100 Cr

Mike F
"shripaldalal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi,
>
> my pivot table is ready and working fine, something like this:
>
> group1 group2 ledgerac
> opnbal debit credit
> group1
> group2
>
> ledger 100
> 200 300
>
> i want something like this:
>
> group1 group2 ledgerac
> opnbal debit credit
> group1
> group2
>
> ledger 100 Dr
> 200 300
>
> OR
>
> group1 group2 ledgerac
> opnbal debit credit
> group1
> group2
>
> ledger 100 Cr
> 200 300
>
> i dont think using a calculated field would work ? can this be done ?
>
> regards,
> shripal dalal.
>

On Mar 15, 4:00 pm, "Mike Fogleman" <mikefogle...@insightbb.com>
wrote:
> You could apply a Custom Format to the cells...
> ?"Cr" would result in 100Cr
>
> Mike F

mike,

thanks a million, it worked like a charm.

best regards,
shripal.