I see your point....you could use a COUNTIF function to count the "1"s....then when you update all your PT it should flow to the pivot chart....does that make sense?
I see your point....you could use a COUNTIF function to count the "1"s....then when you update all your PT it should flow to the pivot chart....does that make sense?
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Yes, it makes sense. Using a COUNTIF was something I was considering, but I couldn't figure out how to implement it properly. If you know how it should be done, I could use some guidance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks