Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem for this relations
I have a table for conversion as this
ItemId Factor FromUnit ToUnit
and I have a table for transactions as
ItemId Qty GroupId UnitId
my question, when I set an expression in the chart as (Sum(Qty) for ItemId / Sum(Qty) for GroupId related with ItemId)
When I do it that I cant right value for conversion equation.
Can you share your file, with some (sample) data?
Grtz Fred
Hi fadibarri
Can you Share your File
How are you writing the expression?
If you want the % breakdown for each group of the items within it, try creating a table with GroupID and ItemID as your dimensions, then use Sum(Qty) / Sum(Total <GroupID> Qty) as your expression.
Otherwise, what is it you want from your conversion table?