how do i display some extra text information in pivot table data area
 

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.

how do i display some extra text information in pivot table data area
 

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

Mike F
"shripaldalal" wrote in message
oups.com...
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.

how do i display some extra text information in pivot table data area
 

On Mar 15, 4:00 pm, "Mike Fogleman"
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.