OFFSET formula in pivot table

[Altamija]

Hello,
I need help with the offset formula below.
=OFFSET('Aging over 90 Days'!$B$3,,,COUNTA('Aging over 90 Days'!$B$3:$B$200),5)

I have created a pivot table(table2) using data pulled from another pivot table(table1) while creating the offset formula.
Would it be possible to adjust the formula so that the last raw(grand total) from the data source pivot table (table1) is not included in the pivot table (table 2)?

Thank you in advance.

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Altamija]

attachment has been reposed below

[Pepe Le Mokko]

Could you please explain what you are trying to achieve with those two PT's?

[Altamija]

Hello,
I need help with the offset formula below.
=OFFSET('Aging over 90 Days'!$B$3,,,COUNTA('Aging over 90 Days'!$B$3:$B$200),5)

I have created a pivot table(table2) using data pulled from another pivot table(table1) while creating the offset formula.
Would it be possible to adjust the formula so that the last raw(grand total) from the data source pivot table (table1) is not included in the pivot table (table 2)?

[FDibbins]

1. Altamija you were asked to explain what you are trying to achieve,and all you did was copy/paste your 1st post - that doesnt help at all. Please explain - in words - what you want to do.

2.
Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Altamija]

I am trying to figure out the correct offset formula which will grab data from the pivot table (table 1) but exclude raw with Grand Total (raw 8) and use to create a pivot table (table 2).
Table 2 should not have Grand Total from Table 1 included as data for table 1. (raw 7)

I have reattach the file.
Thank you

[Altamija]

Hello FDibbins-

Thank you for informing me. I will certainly follow your recommendation. I was looking for a solution-i didn't know that I am not allowed to search for help on multiple sites. Anyway - please accept my apologies.

[Pepe Le Mokko]

You have to add a ink to ALL cross posts before getting any further help here