Pivot Table Range

Hello,

I am entering daily data financial data by date and by where it is coming from.

How do i make to so that the range includes all the eventual data that I will include, for the month or for the year. But shows only the data that is currently entered?

thanks for any help.

So my column titles are date, source, turnover etc.

When I have just done as you said I get a new blank column for some reason and also there is a blank row at the bottom.

Neither of these appeared before.

you can use a Dynamic Named Range, e.g.:

Formula:

Please Login or Register  to view this content.

in the above it is assumed your date column is A (last data entry denotes last row), and your headings are in row 1, modify as appropriate.

then modify your existing PT source range, via Change Source Data on ribbon, to be: _PTData

as data is added to your source sheet the Pivot table, when refreshed, will expand / contract accordingly.

I would suggest changing your data to an excel table and build the pivottable of that table. Tables will auto-expend when new data is added.
that avoids selectiing whole columns and having to filter for blank values.

Excel table explanation
https://support.office.com/en-us/art...9-6c94334e492c

Thanks for your help. I'll look into those solutions and get back to you. Much appreciated.

Hi I have done that.

Thanks that seems to work great.

Now unfortunately when i group dates I can't collapse and expand the dates as i'd like. I have to into group and ungroup field everytime.

Hello,
I have an assignment and I don't know how can I use a pivot table for the following questions.
1- Average Length of Stay of these patients by CTAS (Registration to Time Pt Left ED)
2- Percentage of CTAS 1-3 treated by Nurse Practitioner within 7 hours (Registration to Disposition (DISP))
3- Percentage of CTAS 4-5 treated Nurse Practitioner within 4 hours (Registration to Disposition (DISP))
Thanks for your help.

Sure, Thanks.