http://forums.visokio.com/discussions/tagged/Pivot_view/p1/feed.rss Mon, 30 Oct 17 13:34:53 -0400 Tagged with Pivot_view - Visokio Forums en-CA http://forums.visokio.com/discussion/3270/pivot-view-2.9-blank-rows-in-multi-field-breakdown Thu, 12 Oct 2017 12:01:04 -0400 nick_scangas 3270@/discussions http://forums.visokio.com/discussion/3265/exporting-pivot-view-data-into-xls Fri, 25 Aug 2017 08:14:37 -0400 enrico68 3265@/discussions
I followed what is indicated in the thread http://forums.visokio.com/discussion/comment/10597/#Comment_10597 but I've been able only to extract the details of the elementary records that are the base for the pivot composition.

Is it possible to extract the data as shown in the pivot table?

Since the pivot table is very big I would like to avoid to use the method of selecting cells on the pivot and use the cut and paste option.

]]> http://forums.visokio.com/discussion/3136/pivot-view-styling-colouring-by-the-split-field Tue, 07 Jun 2016 08:29:56 -0400 Phillipa 3136@/discussions
I have a pivot view with various colours in it. My problem is that the labels in the dark colours are being shown in black and are therefore illegible.

Is there something I can do about this?

Thanks
Phillipa


]]> http://forums.visokio.com/discussion/3105/pivot-view-sorting-column-headers-in-descending-date-order Mon, 07 Mar 2016 06:39:47 -0500 dabay 3105@/discussions
I have a pivot view that has the date columns along the x-axis, is there a way to sort the columns in descending order so the latest date appears as the left most column. Below is the screenshot of the original report where it only orders the dates in ascending order.

]]> http://forums.visokio.com/discussion/2899/pivot-view-styling-not-expressed-in-browser-versionss Wed, 01 Apr 2015 03:59:08 -0400 alexandervolk 2899@/discussions http://forums.visokio.com/discussion/187/idea-pivot-view-colour-formatting-difference-columnsrowss Tue, 08 Dec 2009 10:20:39 -0500 Steve_Randall 187@/discussions Thanks, Steve]]> http://forums.visokio.com/discussion/966/pivot-view-manually-adjusting-aspects-of-the-displays Thu, 01 Sep 2011 08:04:57 -0400 johnurry 966@/discussions 1. It would be helpful it were possible to manually adjust the column widths, including the row headers column width. Then if one Pivot View is positioned above another, the columns could be made to align. This would also solve an issue I have on some PCs (but not on others) where long row headers are not fully displayed.
2. The column headers are text and align to the left, whereas the column data being numbers align to the right. Would it be possible to manually adjust the alignment.
]]> 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/2615/idea-pivot-view-table-s-query Fri, 27 Jun 2014 07:19:08 -0400 dpawley 2615@/discussions
Thanks, Danny]]> http://forums.visokio.com/discussion/2588/idea-pivot-view-white-space-and-total-in-one-rows-pivot-view-2 Tue, 10 Jun 2014 10:01:00 -0400 Alexander 2588@/discussions
I have a pivot table displayed using Pivot View version 2 with splits on the vertical axes of 3 fields. The lay-out of the view is far from optimal, with a lot of white spaces in between the rows.

Next to that, I cannot create a single row with the sum of all values above.

I would like to invite you to a screen share in order to show the problem. Hope to hear soon.Thanks!

Alexander]]> http://forums.visokio.com/discussion/2705/pivot-view-sorting-and-ranking-aggregated-recordsfieldss Mon, 01 Sep 2014 07:22:52 -0400 tagarw 2705@/discussions Please see attachment for the problem and help me with this. Let me know if you need more information.
]]> http://forums.visokio.com/discussion/2694/idea-pivot-view-align-multiple-views-to-have-same-orders Wed, 20 Aug 2014 09:17:54 -0400 MatthewLiddle 2694@/discussions
I am looking to have 3 pivot tables with brands on the Y Axis and then split by This year and last year, with a % Change. I have one table for each pack size (small mid large)

The issues is that I have some brands which only appear in one set of sizes (for example a brand may only have large packs). Because of this it a brand may appear in position 5 in one table and 7 on another. I would like it so they are always in the same position.

The 'pivot 2' in 2.8/9 does this perfectly, however I am unable to show % Change.

Does any one have a suggestion of how I can keep brands on the same 'line' / in the same order even though I will have to put them in multiple tables (In order to have my % change)

I have attached a file which has a 2.8 pivot on the left, which is just what I want (but doesn't have % Change) and then two 2.7' pivots which ave a % change but the brands may be in different orders

Many thanks
]]> http://forums.visokio.com/discussion/2672/pivot-view-view-data-exported-to-excels Mon, 04 Aug 2014 03:55:11 -0400 Avizua 2672@/discussions
Thanks, Magali]]> http://forums.visokio.com/discussion/2633/pivot-view-date-order Mon, 07 Jul 2014 03:38:20 -0400 nitiwan 2633@/discussions
I found this forum that Omniscope 2.8 can make the date in thr right order for Pivot view http://forums.visokio.com/discussion/1705 However, it is still not working for me. I have attached file as example, please advise do I have to select any menu/function?

Thank you very much.
Nitiwan]]> http://forums.visokio.com/discussion/2585/pivot-view-pivoting-by-more-than-two-categoriess Mon, 09 Jun 2014 12:14:43 -0400 benjamin 2585@/discussions
I am pivoting by two (2) fields horizontally e.g. [Field 1] , which contains A1, A2 and [Field 2] which contains B1,B2

[Field 1] [Field2]

  A1
            B1
            B2
  A2
            B1
            B2

My problem is that if in the data there is no row which has A2 in [Field 1] and B2 in [Field 2], in the Pivot View it will leave the associated rows empty with no row header or anything.
See example... most probably more clear.
For the Collateralised, Senior Unsecured and Supranational bonds they have only Tier *, however below Tier * there are gaps where Omniscope thinks other examples of tiers should go.]]> http://forums.visokio.com/discussion/2591/idea-pivot-view-grand-total-in-pivot-view-2s Wed, 11 Jun 2014 10:37:26 -0400 Alexander 2591@/discussions http://forums.visokio.com/discussion/2579/pivot-view-removing-margin-lines-below-in-version-2.8 Thu, 05 Jun 2014 04:32:09 -0400 benjamin 2579@/discussions
How do i remove these lines from the table? I only want the lines to show when exporting to the end of table and not of the view.

Thanks, Ben
]]> http://forums.visokio.com/discussion/2581/pivot-view-running-ytd-total-across-columnss Fri, 06 Jun 2014 13:09:15 -0400 s_daffern 2581@/discussions
So in 2013 quarter 1 we spent £50, in quarter 2 we spent £70 with the period total then being £50 + £70 = £120. I would then compare 2014 quarter 1 against 2013 quarter 1in the pivot.

Apologies if this is simple I just couldn't seem to get it to work using the Running Total formula.

Thanks, Steve]]> http://forums.visokio.com/discussion/2577/pivot-view-remove-rowcoloumn-labels-version-2.8s Tue, 03 Jun 2014 12:43:55 -0400 benjamin 2577@/discussions
Please can you advise if it is possible to remove the column and row labels from pivot view tables.

Thanks

Ben
]]> 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/2131/pivot-view-2-new-and-improved-2.8- Fri, 10 May 2013 12:11:12 -0400 chris 2131@/discussions

• Better performance. The old pivot view would often take a long time to calculate and update, particularly when working with large data-sets. You should find the new pivot view much quicker to work with.
  
• You can now select multiple measures. The old pivot view only allowed you to select a single measure.
  
• You can now select any field in the X and Y axis. In the old pivot view you were limited to selecting a single field.
  
• The new Pivot view allows you to tile by one or more fields. Each tile will show a separate Pivot table.
  
• There is now much more flexibility for configuring the look and feel of the pivot view. For example, on the view toolbar you can click the "Preset" button and choose to show the data as a grid or a table. More advanced options that allow you to configure options such as the pane height, label positions etc. are available in the "Layout" and "Style" view toolbar menus.
  
• The new pivot view includes more colouring options. You can now colour by the measure value, the measure name (useful when more than one measures are selected), by a single field or by a fixed colour.
  

Please let us know if you encounter any problems using the new pivot view, or if you have any ideas/suggestions of things we can improve.]]> http://forums.visokio.com/discussion/1506/pivot-view-date-time-fields-and-top-5-text-categories.- Fri, 27 Apr 2012 01:53:12 -0400 rajeshbalu29 1506@/discussions
I have a requirement of creating a pivot with x-axis as months - MMMyy and y-axis by top 5 Categories. Currently, the Pivot View is only supports aggregation by Text Category, but if I convert the MMMyy from Date/Time to Text Category, then it does not automatically sort them properly (chronologically)?

Also I need the same feature which we had in the Bar/Line View restricting only top 5 Text Categories in the Pivot y-axis view?

Regards, Rajesh B]]> http://forums.visokio.com/discussion/2393/pivot-view-axes-value-ordering-version-2.9s Wed, 30 Oct 2013 07:08:20 -0400 davedunckley 2393@/discussions
Is it possible to drag the order of the valuses on the axis, like you can in excel?

Thanks

Dave
]]> http://forums.visokio.com/discussion/2188/idea-pivot-view-2-non-uniform-rowcolumn-sizings Mon, 10 Jun 2013 12:28:55 -0400 milo 2188@/discussions http://forums.visokio.com/discussion/2177/idea-pivot-view-restore-columnrow-differencess Fri, 31 May 2013 06:27:03 -0400 aknotts 2177@/discussions
Thanks, Andy]]> http://forums.visokio.com/discussion/2174/pivot-view-export-pivoted-data-now-enabled Thu, 30 May 2013 04:05:43 -0400 alexPIB 2174@/discussions Are there any plans to make exporting data as a pivot easier?

I seem to remember an 'export as pivot' option on a 2.7 build a while ago but now it no longer exists?]]> http://forums.visokio.com/discussion/2191/pivot-view-2-headers-influence-automatic-column-widthss Wed, 12 Jun 2013 05:29:31 -0400 lowellchung 2191@/discussions
I am a new user at Investec and the new set of reports we want to create require multiple x-axis headers. The problem is that the later groupings are bigger and it is making the format awful.

Someone said I need to use the function "Headers influence automatic column widths", however I can't seem to find it.

Can someone please assist or point me in the direction of a work around for this?

Thanks and Regards,
Lowell]]> http://forums.visokio.com/discussion/2259/idea-pivot-view-2.8-fixing-total-columnrowss Mon, 22 Jul 2013 05:45:50 -0400 DominicChan 2259@/discussions
Is there a way to fix the "Total Row" to the bottom of the table when using the 2.8 Pivot Table?

Is there a way to manually adjust the column width? For example, the Y pane title column (the grouping column), or the X pane title columns (the measures column)

Thanks, Dominic]]> http://forums.visokio.com/discussion/2243/idea-pivot-view-date-field-as-measures Mon, 15 Jul 2013 08:37:36 -0400 ygulla 2243@/discussions
I've tested this in 2.8 b1014.

Yuri]]> http://forums.visokio.com/discussion/280/pivot-view-export-pivoted-tables Tue, 06 Apr 2010 20:28:15 -0400 Pascal 280@/discussions