cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 180
Hi,
I have daily dashboard that I created for work.
It uses pivottable for this months data, but for a number of reasons then uses sumifs to pull in budget and PY data based on date of month % of budget completed/booked at that period of month.
I am using conditional formatting to replicate the pivot table for example Grand total row is blueish anything below pivottable font is white so it wont show..
It all works very well aside from a few sales reps who might contribute to multiple divisions
When I am using the sumifs I am just adding the (divsional sum if +sales rep sum if), so regardless if the drilldown is open or not it will add the two sumifs (one having a value, and one not).
However there are a few sales rep who might contribute to two divisions, and my sumifs do not know that.
Was hoping to use get pivot or something in sumifs to indicate what division sumif should be using. Is this possible?
I have daily dashboard that I created for work.
It uses pivottable for this months data, but for a number of reasons then uses sumifs to pull in budget and PY data based on date of month % of budget completed/booked at that period of month.
I am using conditional formatting to replicate the pivot table for example Grand total row is blueish anything below pivottable font is white so it wont show..
It all works very well aside from a few sales reps who might contribute to multiple divisions
When I am using the sumifs I am just adding the (divsional sum if +sales rep sum if), so regardless if the drilldown is open or not it will add the two sumifs (one having a value, and one not).
However there are a few sales rep who might contribute to two divisions, and my sumifs do not know that.
Was hoping to use get pivot or something in sumifs to indicate what division sumif should be using. Is this possible?