ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula in combination with pivot table (https://www.excelbanter.com/excel-worksheet-functions/192903-formula-combination-pivot-table.html)

Eucalypta

Formula in combination with pivot table
 
Dear all,

Kind of new to pivot tables and hoping that someone out there is able to
help me ;-).

I have a pivot table that generates in colom A country names and in row 2
weeknumbers. The weeks are grouped to quarters evry time I update the table.

To avoid grouping and ungrouping, I am looking for a formula that gives me
the total per quarter per country starting in cell B19.

Thanking you in advance for your kind help.
Eucalypta


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com