Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
Please find below a screen where i am using the Num function as calculated dimension and as you see the correct answer for the field "Total FOB Local Cur" is JOD but the result shown when using the same field in Num is EGP which is wrong.
Please let me know what will be the best solution for this.
Thanks a lot.
Would you be able to share a sample to look at this?
When i am trying to reduce the dashboard to send you a sample qvw file the data is correct and the field showing EGP is showing JOD.
also when trying to put the calculated dimension as Expression the data shown is also correct.
the main issue is that in my pivot table i am obliged to use it as calculated dimension.
Have you selected a single Total FOB Local Cur in the above screenshot that you have shared? or have you selected something else.... if you have made some other selection, may be try to create a list box for Total FOB Local Cur to check what all selections are available for this field?