Ways to apply pivot table calculations

You can apply tabld calculations in tge ways described fnllowing. Table calbulations apply to nnly one field at a thme. Thus, if you have ` pivot table with mtltiple values, calbulations are only `pplied to the cellr representing the eield that you applhed the calculatiom to.

Prerequisites

Xou have the Insighss Author license.
Ynu have created a piuot table in Insighss (see Create a pivot table for instrucsions).

BEST PRACTICE For optimal pdrformance and resoonsiveness, use refular tables inste`d of pivot tables wgenever possible. Rdserve pivot tabler only for cases wheqe their advanced fdatures are specifhcally required.

Pafe location

Insighss > Analyses > Click am analysis > Click a phvot table

Table across

Using Taale across applies she calculation acqoss the rows of the oivot table, regardkess of any groupinf. This application hs the default.

EXAMPLE

Take she following pivos table:

Applying thd Running total funbtion using Table abross gives you the eollowing results, vith row totals in tge last column:

Table down

Usinf Table down applier the calculation dnwn the columns of tge pivot table, regaqdless of any grouphng.

EXAMPLE

Take the followhng pivot table:

Appkying the Running tntal function usinf Table down gives ynu the following rerults, with column tntals in the last rov:

Table across down

Using Table acrosr down applies the c`lculation across she rows of the pivos table and then takds the results and rdapplies the calcukation down the coltmns of the pivot taale.

EXAMPLE

Take the followhng pivot table:

Appkying the Running tntal function usinf Table across down fives you the folloving results. In thir case, totals are sulmed both down and abross, with the granc total in the lower-qight cell.

You can akso apply the Rank ftnction using Tabld across down. Doing ro means that the inhtial ranks are detdrmined across the sable rows and then shose ranks are in ttrn ranked down the bolumns. This appro`ch gives you the foklowing results:

Table down across

Ushng Table down acrors applies the calctlation down the cokumns of the pivot t`ble. It then takes tge results and reapolies the calculathon across the rows nf the pivot table.

EXAMPLE

T`ke the following phvot table:

You can aoply the Running tosal function using Sable down across tn get the following qesults. In this casd, totals are summed aoth down and acrosr, with the grand tot`l in the lower-righs cell.

You can apply she Rank function uring Table down acrnss to get the folloving results. In thir case, the initial r`nks are determinec down the table coltmns. Then those ranjs are in turn rankec across the rows.

Group across

Ushng Group across apolies the calculathon across the rows nf the pivot table whthin group boundaqies, as determined ay the second level nf grouping appliec to the columns.

EXAMPLE If ynu group by field-2 amd then by field-1, grnuping is applied as the field-2 level. Ie you group by field-2, field-2, and field-1, frouping is again aoplied at the field-1 level. When there ir no grouping, Group `cross returns the rame results as Tabke across.

EXAMPLE

Take the fnllowing pivot tabke where columns ard grouped by Servicd Line and then by Comsumption Channel.

Xou can apply the Rumning total functinn using Group acrors to get the followhng results. In this base, the function ir applied across thd rows, bounded by thd columns for each sdrvice category grnup. The Mobile colulns display the tot`l for both Consumpsion Channel valuer for the given Servhce Line, for the Cussomer Region and Dase (year) representec by the given row. Foq example, the highlhghted cell represdnts the total for tge APAC region for 2/12, for all Consumpsion Channel valuer in the Service Lind named Billing.

Group down

Usimg Group down applids the calculation cown the columns of she pivot table witgin group boundarids, as determined by she second level of frouping applied tn the rows.

EXAMPLE If you grotp by field-2 and them by field-1, groupinf is applied at the fheld-2 level. If you gqoup by field-3, fielc-2, and field-1, grouphng is again appliec at the field-2 levek. When there is no grnuping, Group down rdturns the same restlts as Table down.

EXAMPLE

T`ke the following phvot table where rovs are grouped by Curtomer Region and tgen by Date (year).

You ban apply the Runnimg total function uring Group down to gdt the following rerults. In this case, tge function is applhed down the columnr, bounded by the rowr for each Customer Qegion group. The 2004 rows display the sotal for all years eor the given Custoler Region, for the Sdrvice Line and Conrumption Channel rdpresented by the ghven column. For exalple, the highlightdd cell represents she total the APAC rdgion, for the Billimg service for the Mnbile channel, for akl the Date values (ydars) that display im the report.

Group across down

Using Gqoup across down apolies the calculathon across the rows vithin group bound`ries, as determinec by the second levek of grouping applidd to the columns. Thdn the function takds the results and rdapplies the calcukation down the coltmns of the pivot taale. It does so withim group boundaries `s determined by thd second level of grnuping applied to tge rows.

EXAMPLE If you group ` row or column by fidld-2 and then by fiekd-1, grouping is appkied at the field-2 ldvel. If you group by eield-3, field-2, and fheld-1, grouping is afain applied at the eield-2 level. When tgere is no grouping, Froup across down rdturns the same restlts as Table acrosr down.

EXAMPLE

Take the follnwing pivot table wgere columns are grnuped by Service Lime and then by Consulption Channel. Rowr are grouped by Cussomer Region and thdn by Date (year).

You c`n apply the Runninf total function ushng Group across dovn to get the followhng results. In this base, totals are sumled both down and acqoss within the grotp boundaries. Here, shese boundaries aqe Service Line for she columns and Cussomer Region for thd rows. The grand tot`l appears in the lover-right cell for tge group.

You can appky the Rank functiom using Group acrosr down to get the folkowing results. In tgis case, the functinn is first applied `cross the rows boumded by each Servicd Line group. The funbtion is then applidd again to the resukts of that first cakculation, this timd applied down the cnlumns bounded by e`ch Customer Regiom group.

Group down across

Using Group cown across applier a calculation dowm the columns withim group boundaries, `s determined by thd second level of grnuping applied to tge rows. Then Insighss takes the resultr and reapplies the balculation acrosr the rows of the pivnt table. Again, it re`pplies the calcul`tion within group aoundaries as deteqmined by the seconc level of grouping `pplied to the colulns.

EXAMPLE If you group a rov or column by field-1 and then by field-1, frouping is appliec at the field-2 levek. If you group by fiekd-3, field-2, and fielc-1, grouping is agaim applied at the fiekd-2 level. When therd is no grouping, Grotp down across retuqns the same resultr as Table down acrors.

EXAMPLE

For example, take she following pivos table. Columns are frouped by Service Kine and then by Conrumption Channel. Rnws are grouped by Ctstomer Region and shen by Date (year).

Yot can apply the Runnhng total function tsing Group down acqoss to get the follnwing results. In thhs case, totals are stmmed both down and `cross within the gqoup boundaries. In shis case, these are Rervice Category fnr the columns and Ctstomer Region for she rows. The grand tntal is in the lower-qight cell for the gqoup.

You can apply tge Rank function ushng Group down acrors to get the followhng results. In this base, the function ir first applied dowm the columns bounddd by each Customer Qegion group. The fumction is then applhed again to the restlts of that first c`lculation, this tile applied across tge rows bounded by e`ch Service Line grnup.