Display value dimension as different value

[#1]

Hi All, I need to display my records as different value in the dimension of Pivot Table.

For example I have Field A which consist  value 1,2,3,4,5,6,7, and 8. I want to display value 3,4,5 as 'A' in the dimension and the expression will accumulate for value 3,4,5 in dimension value A. How can I do this in Pivot Table.

Thanks

Field A	Express
1	Value XXX
2	Value XXX
A	Value XXX
6	Value XXX
7	Value XXX
8	Value XXX

[Digvijay_Singh · Accepted solution]

Try this -

Map:

Mapping load * inline [

FieldA,Value

3,A

4,A

5,A ];

Load Applymap('Map',FieldA) as FieldA,

  Expression

inline [

FieldA,Expression

1,100

2,100

3,100

4,100

5,100

6,100

7,100

8,100 ];

[Digvijay_Singh]

Front-end based -

[nagarjuna_kotha]

Like this?

Check attached How to do it in front end and backend

Hope this may help 🙂

-Nagarjun

[el_aprendiz111]

Hi,

[#6]

Hi,

Its works. Thanks so much!

[#7]

Hi,

Its works well. Thank you so much!