Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
117
Views
Topic starter
Hello,
I've been tasked with analyzing how much promo activity has affected sales. I'd like to be able to bring in text to a pivot table that shows if there was a promotion for that week. I've tried doing this with the DAX option, but then it seems the SUM function won't work. On the attachment on Sheet 2 is the setup I'd like to have with the sum of sales and unit movement, but I don't want to to make two lines for WK 1 of November. Is there a work around where the promo text activity would in rows going across like on Sheet 3?
Posted : 17/04/2021 2:21 pm
SUM function does not work because you have text in Sales columns, make sure you have ONLY numbers, remove those "-". (see sheet 1 cell D64 for an example.)
Posted : 18/04/2021 11:32 pm
