Trellis

[johnan]

Hi folks!

Ok, i have a Trellis with gauges. And now i want to present the amount in percent in the Trellis:

So i want a second expression with text. Is that possible?

Br

John

[Anil_Babu_Samineni]

Chances are high using Dual('Text' & Sum(Sales)/Count(Name), Sum(Sales))

[johnan]

Alright, to my added expression?

sum(if(match(Status, 'FS','PK',), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

[sergio0592]

Misplaced comma :

sum(if(match(Status, 'FS','PK',), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

[johnan]

Yeah, thanx, but i can't get the dualfunction to work with my expression:

Dual('Text' & Sum(if(match(Status, 'FS','PK'),Sum(Antal/Cs*KrtVikt) / sum(DISTINCT Vikt))

ORG:

sum(if(match(Status, 'FS','PK'), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

[Anil_Babu_Samineni]

Why not like this?

Dual('Text' & (Sum({<Status = {'FS','PK'}>} (Antal/Cs*KrtVikt))/Sum(DISTINCT Vikt)), (Sum({<Status = {'FS','PK'}>} (Antal/Cs*KrtVikt))/Sum(DISTINCT Vikt)))

[johnan]

Yes, working, but where can i see the "text"

Sorry, never use trellis before..

[johnan]

Hi maybe I was not clear enough?

i just want a text on my gauge that show the result in text in the gauge directly.
Now i have to sweep over with mouse to se the result

Br
John

[Anil_Babu_Samineni]

No, I am pretty clear about your intention. Fortunately i missed this conversation.

Anyway, Continuation is could be space is not enough though. Can you use Ctrl+Shift to check space enough for that text. If so, please elapse the space using mouse.

Second thought came to my mind, using "Text in chart" option from presentation tab

[johnan]

Hey, thanx but if i use text in chart it's only shows in the first gauge in my trellis