Multiple dimensions

[#1]

Hey Everyone, good afternoon!

I have a chart which indicates the produccion rates by (Day, Month or Year. It's a hierarchical group.); I want to accumulate only when the dimension is day. Is it possible?

I though to sum (in the script) and accumulate it by dimensions, and make a condition in the chart like that: "If dimension select is day so... if its month so...).

Can you guys help me?

Sincerely, Luiz Bisco

[#2]

use dimensionality() or secundarudimensionality()

if(dimensionality() =1,....

[Anonymous]

Maybe something like this?

=If(

    GetCurrentField([NameOfYourGroup])='Day',

    Sum([YourField]),

    [YourField]

)

[swuehl · Accepted solution]

You can use GetCurrentField( GroupName ) to get the active group dimension field. Use this as condition:

=If( GetCurrentField( YourGroupName ) = Day, Sum(Value), ...)