Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So i have a table bellow are the column and expression . Some how percentages total label is incorrect where as by category is correct
Column 1 Total
if(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}>} [Sold] ))
Column 2 GRE
if(Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] ))
total percentages
if(Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [ Sold] )>0,
Sum({< Is={'T'}, [CAT Name] = {'T I'} >} [Sold] ) / Sum({< Is={'T'} >} [Sold] ))
May be this
Sum({<Is={'T'}, [CAT Name] = {'T I'}>} [ Sold]) / Sum(Aggr( If(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold]) > 0, Sum({<Is={'T'}>} [Sold])) , $(='[' & GetCurrentField([Group Name]) & ']'))))
What is wrong? If 18.1% is not right then what is right?
664518 of 2650572 is 24.95
Opps i attached wrong File . editing soon
Please see the attachment now thanks
Try this
Sum({<Is={'T'}, [CAT Name] = {'T I'}>} [ Sold]) / Sum(Aggr(
If(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold]) > 0, Sum({<Is={'T'}>} [Sold]))
, Dimension))
Thanks Sunny, it worked perfectly , however it has Cycle group dimension , so it only works for one dimension . is there a way to works in all dimension
May be this
Sum({<Is={'T'}, [CAT Name] = {'T I'}>} [ Sold]) / Sum(Aggr( If(Sum({< Is={'T'}, [ CAT Name] = {'T I'} >} [ Sold]) > 0, Sum({<Is={'T'}>} [Sold])) , $(='[' & GetCurrentField([Group Name]) & ']'))))
Thanks it worked out perfectly .