Sync sorting between Pivot & straight table

[pauljohansson]

Hi,

I have a quite intricate sorting question.

I have two objects. One pivot table & one straight table (see attached). I align the straight table beside the pivot table to show minicharts.

The simple setup is:

Pivot Table dimensions:
-------------------------
Category
KPI
Week

Pivot Table expression:
-----------------------
Sum(Value)

Straigt table dimensions
-------------------------
Category (hidden)
KPI (hidden)

Straight table expression
-------------------------
Sum(value)   presented as a minichart using dimension Week

Since I obviously want a row in the Pivot table to correpsond to the minichart I sort both objects on Category & KPI. However, since the week dimension is not in the straight table (only in the expression presented as the minichart) Im not allwod to sort the straight table on weeks!

This leads to that i dont understand how i should sync the sort between the two objects. NOTE! sorting works until a selection is made!

Any ideas are welcome! How have you solved a similar problem?

Thanks in advance,

br
Paul

[#2]

Gotta hate those minicharts - They are SO ugly, And you cant make them larger, and if you got month as dimensions and you wont to show past 7 days example, if will create two charts.

Anyways..

Cant you just sort by expression??