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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago