Visokio website     Downloads     Video tutorials     KnowledgeBase  
Exporting Pivot view data into xls - Visokio Forums
Exporting Pivot view data into xls
  •     enrico68 August 25, 2017 8:14AM
    I'm trying to understand if it's possible to extract to an xls file the data shown in a pivot where functions like the count of unique values are used to calculate aggregated data.

    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.

  • 1 Comment
  •     paola September 11, 2017 10:52AM
    Hi Enrico,
    Please click on any cell in the Pivot view, then use the shortcuts Ctrl+A (to select all), then copy/paste into Excel or a csv file.
    You should end up with a pivot table showing the data with headers, like in Omniscope.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership