11-22-2021 07:44 PM - last edited on 05-24-2023 12:18 PM by JackLacava
Wondering if anyone knows how to scale data in quick views. Looked through the formatting options and couldn't find anything that would do what I'm looking for. ie. 123,445 can be scaled in thousands to 123. Thanks, Scott
Solved! Go to Solution.
11-23-2021 11:26 AM
Hi Scott,
You can define in Excel a custom Cell Style, that will include all the formatting you need including the scaling.
Once the new Cell Style is defined, it will be visible in the QuickView Settings under 'Excel Styles'.
Hope it helps
Liliya
11-23-2021 11:09 AM
When you click on the cell in the cubeview, you have Row and Column Formatting options.
Click on the Ellipses beside Cell format and click Format. The Cell format window has the option of "Scale". You can enter 3 for thousands.
-12 to +12 are the valid values for Scale
11-23-2021 11:26 AM
Hi Scott,
You can define in Excel a custom Cell Style, that will include all the formatting you need including the scaling.
Once the new Cell Style is defined, it will be visible in the QuickView Settings under 'Excel Styles'.
Hope it helps
Liliya
11-25-2021 11:19 AM
Thanks for your reply solution, it works!
09-05-2023 04:18 PM
How did you set the scaling in the formatting?