Pivot table export to Excel number format issue

[#1]

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???

[jagan]

Hi,

Did you converted the format by using Num()?

Regards,

Jagan.

[#3]

Yes, at dimension level....

[#4 · Accepted solution]

I think i get it.... I have to do it at Load script level.... Is working now.... Thanks~~~