Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have this pivot table that display the overall Value of each day and Value of each customer of the day.
The overall Value is a dimension so we cannot perform a sum in the report. But after export, this overall values is converted to text so our user is unable to sum them up too.
I just don't understand why this field is export as text. I had try on setup the field format at Document Properties, Convert them in the dimension and change the alignments but still no luck..... is this a bug in QV or something that I missed???
I think i get it.... I have to do it at Load script level.... Is working now.... Thanks~~~
Hi,
Did you converted the format by using Num()?
Regards,
Jagan.
Yes, at dimension level....
I think i get it.... I have to do it at Load script level.... Is working now.... Thanks~~~