Resume Pivot table from another pivot table

[Patpcv]

Goog Morning,

I have the following issue:

I have a Pivot Table that with many rows with "Execution Services" category that show me a column "Diference Days" with a diference two dates "Initial Date" and "Execution Date". That´s ok.
Now I need another Pivot Table "Pivot Table 2" that resume all categories "Execution Services" but with a column with a quantity from a formula "Max Diference Days >= Cell Reference":

The objective is know how many Execution Services exceed the Max days Execution.

Obs: The days in the panel could be altered.

Ex:


Pivot Table 1 Pivot Table 2 Panel

A1 B1 C1 D1 Category Quantity Category Max Days Execution (Cell Reference)
Category (Execution Service) Initial Date Execution Date Diference Days Installation 2 Installation 3
Migration 1 Migration 2
A2 B2 C2 D2 Address Transference 1 Address Transference 10

Installation 05/15/2019 05/21/2019 6
Address Transference 05/02/2019 05/19/2019 17
Migration 05/08/2019 05/15/2019 7
Installation 05/03/2019 05/08/2019 5
Migration 05/08/2019 05/10/2019 2
Installation 05/08/2019 05/09/2019 1


Thank you very much !

Paulo Cezar from Brasil

[Patpcv]

Bad Format first post

[JeteMc]

Hello Patpcv and Welcome to Excel Forum.
Not understanding Portuguese I am fairly lost. I am guessing that the column "Contagem de Campo6" is difference days.
If that is correct then it would seem that for FTTH - Manutenção the difference days are 41 and 32, both of which exceed the max execution days (3) for that category. I am not sure whether you want to see 2 or 38 as the value in cell G10.
Note that I am not sure that a pivot table 2 will do what you want, although pivot table 1 might be used, along with some formulas, to produce a hybrid table.
If you are interested in attempting a hybrid table type solution please tell us a few of the values you expect to see in column G and unless the rational for those values in very obvious, please tell us why you expect to see them.

[Patpcv]

Hello JeteMc

Thank you so much your reply !

I´m sorry bad english. You are right my problem, in fact in cell G10 i need the value 2 because there is 2 (two) OS´s (Service Orders) that exceed the limit of 3 days to execution like the value j6.
The same of category IVR - Instalação. In cell G14 should be a value 13 because its 13 OS´s that exceed quantity days of execution in cell J11 (15)
The same I need another categories. I need to know how many OS´s exceed the limit of days for execution according Panel. The values in Panel, column J could ber changed.

And why I need another pivot table ? If I want to know witch are OS´s exceed the limit, I can doble click over the cell in pivot table and the OS´s will be showed a new sheet.

So I appreciate so much your help.

Thank you and good lock for you and your family.

Paulo Cezar

[JeteMc]

No need to apologize, I understand the posts, just can't read the column headers.
See if the following may be helpful.
Two columns are added to Table5
Column Z (Days) is populated using: =IF([@Fechamento]>[@Abertura],[@Fechamento]-[@Abertura],0)
Column AA (Over Limit) is populated using: =1*(Z2>INDEX(Processos!J$5:J$25,MATCH(I2,Processos!I$5:I$25,0)))
After adding the columns I attempted to refresh the pivot table but got a 'Reference isn't valid' message.
I then changed the source and the row headers on the pivot table changed also.
I added the 'Over Limit' field to the values of the pivot table, summarizing by SUM.
Looking at the numbers they seem correct, and you can select and inspect OS's as you requested (see Sheet1).
Let us know if you have any questions.

[Patpcv]

Good morning JeteMc !

Thank you so much your help. Help me so much !

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.