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 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago