Quickview column formatting

Question

how can i get 2 columns on a quick view to be shown as %?&nbsp;

Mustafa_A · Answer

Hi&nbsp;RustyShacklefor&nbsp;if I'm understanding your question correctly. Your trying format your numbers to "Percentage" .You can easily do that within Home&gt; Number Formatting or by selecting your desired column and right clicking on it.:&nbsp;&nbsp;Let me know if that works. Cheers!&nbsp;&nbsp;&nbsp;

RustyShacklefor · Answer

that works, but I was trying to change it in the quick view so when every time I update it I wont have to change certain columns to a % every time .&nbsp;

Mustafa_A · Answer

I agree. The formatting doesn't stay locked in.Try this!&nbsp;&nbsp;

RustyShacklefor · Answer

i just want one column to be a percent. that will turn everything into a percent.&nbsp;&nbsp;

Mustafa_A · Answer

As far I know - that's a limitation with QV. If you refresh the worksheet, than it will reset the number formatting.One possible solution would be to create this within Cube View. This way you can retain the formatting (e.g. Percent)&nbsp;You also have an option in Excel-Addin to import a CV.&nbsp;

Forum Discussion

Quickview column formatting

5 Replies

Related Content

Conditional Formatting on BWPercent column

QuickViews calculations

Quickview data difference

QuickView 'Where' condition

QuickTips: Cube Views - Row and Column Suppression