Help with Formula

Nemo1 — Thu, 20 Mar 2025 15:19:10 GMT

Hello everyone,

The situation is the following...

I have a dimension that has 7 different variables, and I have a measure, and I need to create a Pivot Table out of them, which only needs to be applied to one specific store.

The variables from the dimension in the Pivot need to follow an specific order.

This should be the order:

First variable is a currency
Second is currency
Third is %
Fourth is just a number
Fifth is a number
Sitxh is a number
The last one is a currency.

So far I have this formula, which only helped me to correctly sort the variables from the dimension ir oder, and to filter by the store... The problem is, that all my dimensions appear just as numbers, and I need to have them, either as % or currency or just a number...

If(

Len(Trim(YourDimension)) > 0

AND Match(YourDimension, 'Value1', 'Value2', 'Value3')

AND Match(Store, 'StoreA'), // Filtering only for 'StoreA'

Dual(YourDimension, Match(YourDimension, 'Value1', 'Value2', 'Value3'))

)

i would appreciate some help

cheers

Re: Help with Formula

Chanty4u — Thu, 20 Mar 2025 16:32:44 GMT

Try this

If(

Len(Trim(YourDimension)) > 0

AND Match(Store, 'StoreA'), // Filtering only for 'StoreA'

Dual(

YourDimension,

Match(YourDimension,

'Currency1',

'Currency2',

'Percentage',

'Number1',

'Number2',

'Number3',

'Currency3'

)

Re: Help with Formula

Nemo1 — Tue, 01 Apr 2025 13:28:49 GMT

it didnt work 😞

topic Re: Help with Formula in App Development

Help with Formula

Re: Help with Formula

Re: Help with Formula