Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears, I have a pivot table with number of dimmension fields. When i export numeric data into excel they turn into text format. Expresions keep the proper format. I tried to use round and num functions without success also seetings in sheet properties are correct. Does anyone has any idea ? Thanks for any hints.
Hi,
Right click on pivot table --> Properties --> Number --> Select your Expression --> and select numbers
Regards
ASHFAQ
In pivot properties you can only change settings for Expressions i'm trying to handle Dimmension settings.
Attach sample qvw with data please and scenerio
Regards
ASHFAQ