Re-using a particular value from a cube

tableaucommunity@tableau.com — Wed, 09 Jul 2014 14:53:08 GMT

I am a newbie at Tableau and trying to run a calc based on a cube. Let's imagine we have a cube with a dimension called Scenario and associated values:

Scenario	Value
0	2
A	10
B	23
C	4
D	9

I need to subtract the value associated to scenario 0 to all scenarios to give something like:

Scenario	Value	Calculated Field
0	2	0
A	10	8
B	23	21
C	4	2
D	9	7

Have tried picking the scnerio value 0 by creating a Calculated Member like

{[Value],[Scenario].['0']} but it doesn't return any value

How shall I proceed?

thanks for your help

"Unknown function RAWSQL_REAL called" - am I missing a library?

tableaucommunity@tableau.com — Mon, 07 Jul 2014 16:46:09 GMT

Running Tableau 8.2 Professional Edition and cannot see any of the RAWSQL functions. Do I need to install a specific library?

Please note that this is the evaluation version but it's supposed to be complete.

Thanks

Content in Tableau Community Forums

Re-using a particular value from a cube

"Unknown function RAWSQL_REAL called" - am I missing a library?