How to replace the values of a dimension with text?
Hi All,
I was wondering if anybody know if there is a way to replace the values in a dimension in a straight table, so that instead of showing the actual values of the dimension a text string is shown in the table column?
In my situation i have a source table that looks something like this:
sales1
sales2
euro
1
1
1000
2
2
2000
3
3
1500
4
4
3000
where sales1=sales2 (duplicate column but with different names).
What i would like to make is a straight table that look like this:
Open in ERP
Sales order
value
Open document
1
1000
Open document
2
2000
Open document
3
1500
Open document
4
3000
The 'Open in ERP' column should contain the values of source column sales1, but the real values should be hidden and instead the coulmn should only show 'Open document'. However when selecting for example 'Open document' on the first row,it should make a selection so that sales1=1.
