I have 2 Excel sheets attached: "Data Sets" & "Copy_of_Data_Sets2" - - "Data Sets" is the data to be worked with and on. "Copy_of_Data_Sets2" is the example/reference. I need following requirements to be fulfilled but not sure how to accomplish those.
A. For TAB "RAW - CA"
1. Include the Same slicers as in 'Copy_of_Data_Sets2' Excel file. Additional Slicers I want included: "Hydraulic / Manual" , "Size" , and
"Age of Asset / Year manufactured"
1A. "Age of Asset / Year manufactured" -> I don't think I need to include specific date as listed - instead I could do M/Y or Q1/Y. I am not sure.
2A. Can I calculate against "Age of Asset / Year manufactured" and "TRAQ Date Reported" -> I want to showcase the lifespan of a specific asset before an issue is open for that Asset #. With this, I believe I may have to follow a consistent format for "Age of Asset / Year manufactured" (M/Y)
3A. Can you make the Slicers a bit more Dynamic? For example: If I select year 2017 -> a total sum count will appear in it's respective category i.e.
'100 Mesh / Leaking' ; 'Grease' ; 'January' ; 'February' ; 'Northeast' ; 'Rockies' ; 'Alice' and etc.. And then if I select '2017' -> 'Grease',
it'll then show total sum count under "Month" ; "Region" and etc.
2. I want something similar to what is created in example, the pivot table with graph for my "RAW - CA" TAB. Like the "Graph" TAB in 'Copy_of_Data_Sets2'.
B. For TAB "6.26.17 RAW - AF"
1. I want to create a Graph very similar to my TAB "AF - Graph". In "6.26.17 RAW - AF" I have data going back as far as 2013, so i'd like to systematically show Customers reflected for the respected year with the number of occurrences (Incidents reported) for them. I would also like to show the "NPTHours" and "NPTCostEstimate" associated to the Customer and the Year. Then Finally show All years with total count of each Customer with their 'Hours' and 'Cost'.
2. I want something similar to what is created, the pivot table with graph for "6.26.17 RAW - AF" TAB. Like the "Graph" TAB in 'Copy_of_Data_Sets2'.
Bookmarks