dynamic report and chart

[NAVEEN C N]

Hi All.

Please find attached spreadsheet showing the reports date wise on differnt sheets.( 4th sept, 5th sept, 6th sept..........)

I need a report ( master report) in such a way that if i select the dates ( from and to) and MID, which should list all the values ( batter voltage, AFM, Binary events, reset count, RF failure counts, first AFM and last AFM ) datewise. ( report attached for your reference).

For excample if i select meter ID 2 and date from 04/09/2014 to 16/09/2014 the report should list all the values datewise.


date
01/09/2014
02/09/2014
03/09/2014

and also on the same sheet i need charts for battery voltage, AFM counts, Reset counts...

 

[Luke M]

Before getting to far, any chance you could improve the design of your workbook and have all the data on a single sheet? Spreading it over multiple sheets make data analysis a lot harder. If it was a single sheet, with an additional column showing date, this question would be a breeze to answer.

 

[NAVEEN C N]

Yes.. i do not have any issues with merging of sheets and adding the dates..

Please proceed and let me know the result..

Thanks in advance for your help...

 

[Luke M]

In the attached, I've grouped all your data onto a single sheet, and was then able to produe a PivotTable showing desired information. You can select one our ID's and dates as desired.