Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to create a table using the following field.
promoCDE which has values such as 'Adult' 'MACBAN' 'FSTBRK'
I wan to build a table that has these different types of 'promoCDE' as the dimensions and then use the field =[Net Sold Qty] as the expression. My output would be:
promoCDE [Net Sold Qty]
Adult #,###
MACBAN #,###
FSTBRK #,###
May be use set analysis instead
Dimension
promoCDE
Expression
Sum({<promoCDE = {'Adult', 'MACBAN', 'FSTBRK'}>}[Net Sold Qty])
May be use set analysis instead
Dimension
promoCDE
Expression
Sum({<promoCDE = {'Adult', 'MACBAN', 'FSTBRK'}>}[Net Sold Qty])