To Count Unique Value with Pivot
Hi all,
I have a question, really hope that you guys can help me.
OK it's like this, I have 1D data, headings are, for eg
1. Outlet Name
2. Date
3. Product Name
I insert in the FIELD as :
ROW = Outlet Name
COLUMN = Date
How do I obtain the VALUES, as, 0 & 1. 0 = Outlet Name not appear at that particular data, 1 = Outlet Name appear for certain date.
Do you get, what I'm trying to say?
Really hope you guys can help me in this one.
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago