This post is an extension to the one I posted here – Segment towns according to volume contribution and market share. Here’s a simple dataset of Shampoo sales in the state of Rajasthan, India. For a chosen segment, one may want to segment the 4 towns based on the following conditions: Based on the two screenshots […]
Read More →
{ 3 Comments }
Here is a simple two column dataset which shows EmpID in column A and DateWorked in column B. My objective is to filter the table to show those employees who worked ONLY on August 17 and August 18. I’d like to exclude employees who: Did not work on both these days; and Worked on both […]
Read More →
{ 0 Comments }
Assume a five column dataset – ID, Age, Gender, Time and Class. For chosen ID’s, the objective is to: 1. Assign a Rank (in ascending order of time i.e. lowest time will be rank 1 and so on) to each ID 2. Determine the overall place of each ID – Count of unique time entries […]
Read More →
Segment towns according to volume contribution and market share with a slicer
{ 0 Comments }