2 Replies Latest reply on Dec 23, 2017 10:54 AM by Gabriel Fiorelli

# [How to Order] - Computed using table across measure

Hello.

First of all. Sorry for my not so good english. And also, it's the first time that i'm posting here.

Problem:

I'm trying to order by those columns values in that worksheet. But until now I wasn't able to do that.

Description:

The value in "2- Part 2" means that in this part there's -3,69% compared to the "1-Part 1".

The "3 - Part 3" have -9.58% compared to the "2 - Part 2". Following this pattern for each line.

But, the tableau function to order does not appear.

This field is computed by using Table (across).

The Measure is calculated by: (IF FIRST() = 0 THEN 0 ELSE (ZN(SUM([Players])) - LOOKUP(ZN(SUM([Players])), -1)) / ABS(LOOKUP(ZN(SUM([Players])), -1)) END)

The packaged workbook is attached.

Worksheet:

• ###### 1. Re: [How to Order] - Computed using table across measure

Hi Gabriel,,

Welcome to the community.

This is little bit tricky and please spend some time to digest (It' not easy)

In this case, the %age calc is horizontal and sort is vertical.

So Tableau need each layer of calculated field (+ alpha).

And it's quite difficult to handle 2nd dat asource field from primary, so I put primary data source's "Pais" as sort key.

From here, very complicated, then follow the picture step by step very carefully.

Regards,

Shin

2 of 2 people found this helpful
• ###### 2. Re: [How to Order] - Computed using table across measure

Thanks @Shinichiro Murakami, it was REALLY usefull.

It took some time to me understand, but it solve my problem, I was changing the entire data set to fit in a situation where I could sort the data. This solution saved my time.

Thanks again.
Fiorelli.