How to display alphbet in Pivot Table

[RC588]

Hi,

Please help.
How to display alphabet in pivot table?
Example below: if $$ show 1, display "A", if $$ show 2, display "B" and etc, ...

[TABLE="width: 255"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"]01-02-14
[/TD]
[TD="align: right"]02-02-14
[/TD]
[/TR]
[TR]
[TD]Values[/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[/TR]
[TR]
[TD]$$[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[mole999]

The easy way would be to add a column to the data and then use that in the pivot, to do it on the fly in the pivot may not be possible

 

[RC588]

Hi Mole999,

I have tried, and it can't display alphabet too.
What I have done are:
(a) Insert column with reference 1= A, 2= B
(b) Pivot it

But the pivot is showing # not alphabet. Is there anything to do with cell format?

Thanks

 

[mole999]

when you added the column, did you then expand the range of the pivot and refresh the data. I can'r see why # would be presented anything obvious in the filter

 

[RC588]

Hi Mole999.

Yes, I did expand the pivot table data source.

Thanks.

 

[Fazza]

Hi,

It seems a quirky question. Can you explain further what is required?

A pivot table summarises numeric data. It isn't the tool to use to show text.

To display alpha characters maybe try a cross-tab query table, as it can show text. In particular using MAX or MIN. I can't remember if there are other functions that return text. So you could have the cross-tab return text, and it looks similar to a pivot table. SQL might be like below. However depending on exactly what you want this may or may not be suitable. By the way I've given no thought to what happens for values > 26.

HTH. Regards, Fazza

TRANSFORM MAX(CHR(fieldname)+64)
SELECT row_field/s
FROM data_source
GROUP BY row_field/s
PIVOT column_field

 

[scottsen]

Does seem an odd request. if you really need it... maybe a big IF() or SWITCH() ?