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

S

shripaldalal

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.
 
M

Mike Fogleman

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

Mike F
 
S

shripaldalal

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top