Skip to Content
0
Jan 12, 2023 at 10:35 PM

SAC - How can I use a custom combination of Measures and Account dimension within a table ?

147 Views Last edit Jan 12, 2023 at 10:36 PM 2 rev

Hello Experts,

I'm using a new model type for planning purpose.

I have 2 measures (Amount and Quantity) and an account dimension (GL_Account)

In a standard table, if I select both GL and measures I'll have all the combinations possible but I'd like to choose specific combinations like : Eg. I don't want to display the quantity for some GLs.


For now, I'm using 'hide' function but it's time consuming and not as clean as expected.

I know I can't use cross calculation with Account dimension and measure : But any idea how to by pass ?

Thanks a lot !
Camille