Hia BO Pros,
I am currently creating a Dashboard based on a BEx Query.
In BEx Query, all the Currency are displaying accordingly in every cell.
For example:-
BEx Query ========= Q1 Q2 Q3 Q4 99.00MYR 45.00MYR 56.00MYR 78.00MYR 232.00MYR 23.00MYR 98.00MYR 29.00MYR
However, when I display the Query table by using Dashboard via 'Selector > Spreadsheet Table'.
The the table displayed with some of the cell with missing Currency, as below:-
Dashboard ========= Q1 Q2 Q3 Q4 99.00MYR 45.00MYR 56.00MYR 78 232 23.00MYR 98 29.00MYR
I have tried all sorts of way, but it still doesn't work.
Any help is much appreciated.
Many thanks