I need some help here with Excel/PowerPivot.

I'm extracting data each month for statistics. The data/fields are the same each month. However, as the data is large, only PowerPivot can handle this extraction.

This is an example of the type of data I'm extracting for a Laboratory:



Identifier Type of Specimen Test Name Run Date
123456789 Patient Cholesterol 11 Nov 2016
223456789 QC Calcium 05 Nov 2016

If the request is to have this monthly report combined into Quarterly ie Oct/Nov/Dec into 1 report, how do I perform this combination without any knowledge on programming? The relationship function ins powerpivot only allow files with related data but not exact fields....

Thanks!

Can you create a Pivot Table with Powerpivot then group the dates by Quarters ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This cannot be done if I have 3 individual power pivot data files...

How many records do you have in each file?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post