PIvot View: Export Pivoted table?

April 6, 2010 8:28PM

I created a pivot table and I want to export it in Excel as I view it in Visokio. However, when I go to Tools > Export View Data, I get the underlying un-aggregated dataset. Is there a way to export the pivot table in Excel as shown in the Pivot View?

steve · April 7, 2010 1:41PM

Not currently, but you can select all (click in table and press Ctrl-A) then copy (Ctrl+C) then paste (Ctrl V) into Excel.

Choose "Pivot view > Tools > Inline/selectable totals" first to ensure you include the totals.

paola · March 19, 2012 8:47AM

See also:
http://forums.visokio.com/discussion/797

acohen · June 14, 2013 12:08PM

Hi, the copy/paste technique does not seem to work at all in Omniscope 2.8 . Please advise.

steve · June 17, 2013 4:18AM

Duplicate of http://forums.visokio.com/discussion/2174/idea-pivot-view-2-export-pivoted-data-from-views/p1

Welcome!

Categories

Ideas Parade

Tagged