Hello,
I ran into a brick wall and I am stuck. So my end goal is trying get the sum total of the "Totals" row from selecting the dates from the slicer. I am not sure if I am explaining this right but I made an example of it. Is it even possible? What I tried to do is =SUMIFS(Table1[Pieces Loaded],Table1[Week of Month],Slicer_Week_of_Month,Table1[Month],Slicer_Month)
It did not work =( please help. Thanks
Anyone know any other way to do this?
Probably, you looking something like this.
(with an pivot table)
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
have you searched in the google
@oeldere that could work but the only downside is that if I have 50 total lines it will take up 50 rows
@janepaul yes I tried to google what to do, I found a couple but it involves powerpiviot and data models which I am not really good with and do not truly understand it as well.
don't get that repond.
Please Login or Register to view this content.
You can select on the criteria you need info about.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks