http://forums.visokio.com/discussions/tagged/percentages/feed.rss Mon, 30 Oct 17 16:09:40 -0400 Tagged with percentages - Visokio Forums en-CA http://forums.visokio.com/discussion/2929/pivot-view-colour-coding-tables Fri, 08 May 2015 07:39:58 -0400 dpawley 2929@/discussions

Hi

Posted on a discussion a while back now about colour coding within a Pivot Table. This was something that has got me thinking (scratching my head) for a while now. Visokio have a number of ideas and suggestions that come flooding in and this is small in comparison to others they receive - so was never implemented.

So I decided to carry on and crack it with their help!

Basically, I had a very large data set that I used a pivot table to report to my business some key measures (Volume, sales, share of category etc). But when using the pivot table, especially when calculating / formula in a pivot table, colour coding increases/decreases changes was proving impossible. Also too many formulas in a pivot table can slow down the report. So Visokio's advice was to calculate any formula columns within the data manager and then pull these through to the pivot table as a value rather than a formula.

In doing this, I was able to have a value calculated in the data manager, pulled through in to the pivot table as a value/measure. Then had the ability to use this value to colour the pivot table based on this. To colour code, you will need to go the "filters", "Field Options", "value ordering" and complete your colour criteria you require. Next you need to select the "Colour" option on the pivot table, "By Single Field" and select your value you have created, then "According to value field".

I have attached an example of my pivot table coloured. "TY", "LY" are values in the data set, "Var" was calculated in the Data manager View (as explained above) and "Var %" is a calculation within the Pivot table. The Pivot Table has been colour coded by the value "Var". This has made the pivot table a dynamic colour coded table depending on what you filter on.

Job done

Thanks

Danny
]]> http://forums.visokio.com/discussion/2531/pivot-view-displaying-percentagess Thu, 24 Apr 2014 03:41:11 -0400 Valentina 2531@/discussions
Thanks in advance]]> http://forums.visokio.com/discussion/1046/percent-change Wed, 12 Oct 2011 21:03:11 -0400 hgross 1046@/discussions
Is there an easy way to calculate percent change month to month? If I'm aggregating by date in column 1 (histogram monthly) and I have a value in column 2 as the monthly total, how can I easily get the third column to show the percent increase or decrease over the past month?

Any suggestions would be appreciated!

Thanks!]]> http://forums.visokio.com/discussion/685/pie-view-displaying-only-percentages-on-pie-but-showing-percentages-and-values-when-hovering Tue, 22 Mar 2011 08:17:12 -0400 Alk 685@/discussions
If I only click Tools and tick "Show Percentages", the percentages are shown in the pie, but when hovering over the pie, it would not show the values - only the percentage.

I think is useful to have an option allowing a combination of the above views; show the percentage on the pie and when the user hovers over it, show the percentage AND the value.

This is primarily a problem when we have small pie-charts.]]> http://forums.visokio.com/discussion/656/idea-pivot-view-percentage-displays Fri, 18 Feb 2011 10:25:55 -0500 brian.lau 656@/discussions
Thanks, Brian]]>