Tagged with Pivot_view - Visokio Forums http://forums.visokio.com/discussions/tagged/Pivot_view/p2/feed.rss Mon, 30 Oct 17 13:37:12 -0400 Tagged with Pivot_view - Visokio Forums en-CA Pivot View: Copy Result as Pivot Table into Excel? http://forums.visokio.com/discussion/2026/pivot-view-copy-result-as-pivot-table-into-excels Thu, 21 Feb 2013 10:09:31 -0500 bfromson1 2026@/discussions
The "export view data" option exports all the underlying data - in a Table View the export view data actually exports the table as viewed?]]>
Outputs: Batch PDF Category fields reverting to Text? http://forums.visokio.com/discussion/2157/outputs-batch-pdf-category-fields-reverting-to-texts Tue, 21 May 2013 10:18:11 -0400 Ed_Roberts 2157@/discussions
Is there a way around this (without presumably having to firstly batch output to IOK and then create another step to convert to PDF ?

Thanks, Ed]]>
Pivot View: Suppressing blank values in Pivot View 2? http://forums.visokio.com/discussion/2051/pivot-view-suppressing-blank-values-in-pivot-view-2s Fri, 15 Mar 2013 10:11:12 -0400 grahamb 2051@/discussions Idea: Pivot View - Colouring of cells by formula measures? http://forums.visokio.com/discussion/2015/idea-pivot-view-colouring-of-cells-by-formula-measuress Tue, 12 Feb 2013 16:22:34 -0500 jonacostes 2015@/discussions
I also created the calculated field in the Tables View but when selecting in the Pivot view, the formula just aggreated the calculation.

Hope you can help me. Best regards,]]>
Pivot View: Version 2.8 - values not displaying? http://forums.visokio.com/discussion/1957/pivot-view-version-2.8-values-not-displayings Wed, 19 Dec 2012 04:57:33 -0500 bfromson1 1957@/discussions
I set up a pivot table and the table entries all appear blank. Hover over a cell and the value is displayed, but the table itself appears to be blank. Have I inadvertently set a white font on white background or has something else happened?

Thanks]]>
Idea: Table/Pivot View column and values styling? http://forums.visokio.com/discussion/1925/idea-tablepivot-view-column-and-values-stylings Thu, 29 Nov 2012 04:23:28 -0500 enrico68 1925@/discussions
- apply formatting to reported values (including different dates and numbers representations) -
example: show all values scaled/divided by 1000, ..., 1,000,000;
- apply formatting to whole columns and rows
examples: centering values, representing negative values in red or between brackets, show different kinds of border to divide sections of a tables - e.g. details and summary).
]]>
SUBSET functions: Non-empty record count? http://forums.visokio.com/discussion/1839/subset-functions-non-empty-record-counts Wed, 17 Oct 2012 05:34:17 -0400 mohamed 1839@/discussions
"SUBSET_NONEMPTYCOUNT([Sumofvalue], SUBSET2([Store Description],[Week]))"

Please see attached file and look at the formula "Week Count", the top value should return 34 but it returns 52. I am not sure where I am going wrong.

Please see the Pivot view, it shows the Weeks against all the stores where I see empty record, I would like to discard in the calculations.

Regards, Mohamed]]>
Pivot View: Colouring and Opacity of Backgrounds http://forums.visokio.com/discussion/1051/pivot-view-colouring-and-opacity-of-backgrounds Fri, 14 Oct 2011 12:57:51 -0400 walsh 1051@/discussions Idea: Pivot View 2- formatting options? http://forums.visokio.com/discussion/1400/idea-pivot-view-2-formatting-optionss Fri, 16 Mar 2012 16:17:54 -0400 schergr 1400@/discussions
I know..l know, it's still experimental, but you can't expect to keep us away from great stuff like this ;)]]>
Enlarge Coloumn Header Height in Pivot view? http://forums.visokio.com/discussion/1316/enlarge-coloumn-header-height-in-pivot-views Thu, 16 Feb 2012 13:01:06 -0500 benjamin 1316@/discussions
(I.e similar to what you are able to do currently in table view by increasing the row height of the coloumn headers)

Thanks...Ben]]>
Pivot View: Improvements to Pivot 2 View? http://forums.visokio.com/discussion/1256/pivot-view-improvements-to-pivot-2-views Thu, 26 Jan 2012 07:21:27 -0500 indranildatta 1256@/discussions
I'll take the opportunity to enlist a few enhancement requests that I have on Pivot 2:

1. An option to turn on/off the font sizing based on measure value.
2. An option to turn on/off grids inside the pivot table.
3. Options to place the vertical pane labels on top/bottom, and similarly a left/right option for the horizontal pane label..
4. Option to set "No background color". Currently, even if I set the bg colour to white, it is set as grey.
5. Seperate options to set the horizontal/vertical axis pane label orientations.

I think once we have these options, this view can completely replace the Excel pivot table option, so anything you can do to prioritise is highly appreciated.

Cheers!
Indranil]]>
Pivot View: How to export only a Pivot View as an Excel file? http://forums.visokio.com/discussion/797/pivot-view-how-to-export-only-a-pivot-view-as-an-excel-files Wed, 01 Jun 2011 05:27:46 -0400 Kefsid 797@/discussions Pivot Headers http://forums.visokio.com/discussion/689/pivot-headers Thu, 24 Mar 2011 13:03:40 -0400 chrisamott 689@/discussions Idea: Pivot View - Percentage display? 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]]>