2 Replies Latest reply on Mar 13, 2013 11:42 AM by Tracy Rodgers

How to Sort by Numeric Distribution

Ka Chun Wong Mar 13, 2013 12:04 AM

Hi everyone,

I have calculated the Numeric Distribution using this formula:
Countd(Stores_ID)/Total(Countd(Stores_ID))

However, I cannot use this in Sorting by Field.

I found out that in sorting or filtering, I cannot use the functions of table calculations. Does anyone know why and how to solve this?

Tommy

1. Re: How to Sort by Numeric Distribution

stryder dsf Mar 13, 2013 4:56 AM (in response to Ka Chun Wong)

Hello Tom,
I think you could create a field with the given calculation and then use it as a field to sort your values in the table.
Hope this helps
Like Show 0 Likes(0)

Actions
2. Re: How to Sort by Numeric Distribution

Tracy Rodgers Mar 13, 2013 11:42 AM (in response to Ka Chun Wong)

Hi Ka Chun,

It's not possible to sort by Table Calculations. This is mainly because table calculations are highly dependent on what is in the view, and at any time the view can change or the way that the Table Calc is computed can cause the values to change, thus giving a different output for the sort.

You'll probably just want to sort by the Countd(Stores_ID) in this case.

Hope this helps!

-Tracy
Like Show 0 Likes(0)

Actions

Tableau Community