Home › Discussions › Questions & Answers › How to configure a pivot table in Blitz Report template

How to configure a pivot table in Blitz Report template

Avatar photoCustomer Questions & Answers 7 replies

I am trying to build a new template that generates a pivot table showing balances by period. What are the four main components I need to configure in the pivot table section?

7 replies

  • Support Enginatics

    The pivot table section is divided into four main areas. They are Filters, Columns, Rows, and Values.

  • What is the purpose of the ‘Filters’ section, and how does it differ from ‘Rows’?

  • Support Enginatics

    The Filters are used to restrict the underlying data being summarized, typically by attributes like GL account or Department. The Rows section defines the data summary level for each row in the pivot table.

  • For my example of balances by period, where would ‘Period’ go, and where would the ‘Amount’ go?

  • Support Enginatics

    Since ‘Period’ determines which data points appear in separate columns, it would be defined under the Columns section. The ‘Amount’ balance data, being the numeric figures you want summarized, would be defined under Values.

  • For the ‘Values’ section, how do I specify that I want the sum of the amounts?

  • Support Enginatics

    You use the Aggr. (Aggregation) setting. This allows you to specify how to aggregate the numeric data, with choices including average, count, min, max, and sum.

  • You must be logged in to reply to this post.