Help with Formula

[Nemo1]

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

[Chanty4u]

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' 

    )

    )

)

[Nemo1]

it didnt work 😞