I am trying to create Bell Curve from data, i.e.
x = number of shoes
y = number of records
From the data, most records, i.e. women have one pair of shoes, so 1 would be the center of the x axis.
How to approach this? Here is what I have so far
Put "Pair of Shoes" on the columns shelf. Change it do a dimension. I would leave the data type as a number and make it continuous.
Then put SUM(Number of Records) on the rows shelf, and make sure it is continuous.
You'll see a distribution, but it won't look like a bell curve