Excel Dashboard creation help

I am trying to create a simple dash board using only Excel and no VBA. What I am trying to do is I want to create dependent drop downs and link up drops downs that will pull out the required data individually or with combination of those two. For example, let's say

A column has Dates of transaction,
B column has Item name
C column has Units
D column has Month name
E column has Shifts (Morning or Evening)

I am trying to make a dash board that will pull total Sum of individual items based on

Only Date wise
Datewise + shift wise
Month wise
monthwise + shift wise
I managed to create drop down list for dates, months, and shifts but i dont know the way how to link the individual drop down lists together to pull the data based on the selection. which function i should use here and how?..Any help plz?

Hi and welcome ot the forum see if the attached will get you headed in the right direction?

1) How to click on star- you mean selecting number of stars under "Rate this Thread" section above?

No, on the bottom left of your post, you will see a star (add reputation)

2) If i mark this closed, will i still be able to comment on here and ask some general question to the above query? (Sorry- I am new to this forum and not so experienced on Excel)

If you still have questions related to the same topic, dont mark it solved. If you have questions regarding a different issue, mark the thread solved and start a new thread

3) When i tried to include new data to A11 cell, i mean new date on "Raw data tab", the helper column showing me Value error when i typed =MONTH(A11). Can u please tell me why it shows like that? coz i followed the exact formula on the above cell.

I have modified that formula to be...
=IF(A2="","",MONTH(A2))
Im not sure that this is what is causing your problem though. I have a feeling you are not entering a correct date. Im not sure what your regional settings are, but it looks lie dd/mm/yy? If you are entering day/month, try entering month/day (or the other way round)

4) On the Main Page the month drop down shows in serial number format, can i change it to mmm-yyyy format?

Not sure which cell you are referring to, but you can change the format to whatever you want. A date is really just a 5-digit number that represents x-number of days from 1/1/1900. The formatting is just so that people can understand it better

5) while searching for solution earlier everywhere, i saw trainers used some kinda INDIRECT function to link up cells. what is that by the way?

INDIRECT() is a function that is used to convert text to something that excel can use in a formula. say for instance you have the letter Z in A1...
=INDIRECT(A1&1) will give you the results in Z1
That is a very simple example for that, but it can be used to reference sheet names and range names, among other things

Happy to help and thanks for the feedback and kind words