Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I am using straight table. I have to show total generated by column 2 on total generated on column 3.
Please find attached screenshot , is it Possible to perform this?
Thanks in advance,
in ur first expression; change it from
count(distinct [Line Desc 1])
to:
if(Dimensionality()=0,Count( total Distinct {<AccountDesc>}[Item-Branch Key]), count(distinct [Line Desc 1]))
result:
Hi Ashish, very strange requirement . If possible please share the reason for it... just for my general knowledge.
I learned about this possibility yesterday from celambarasan but not sure if it works. please try this on the measure you're using for products, Just replace the aggregation and the right field names:
If(Alt(Rowno(),0)=0, Sum(%Items), Count(Products))
I hope it's helpful
Cheers,
L
try:
if(Dimensionality()= 0,sum(aggr(Sum(% of Items),Account)),Count(Products))
Hi Luis
Thanks for responding , I tried with your expression however its not working.
we have one requirement to show same total for multiple columns . we can do this in excel but not sure ab
Can you please provide sample file
in your first column, as an expression
if(dimensionality()=0, sum(total measureOfTheSecondColumn), sum(MeasureOfTheFirstColumn):
Example:
IF(Dimensionality()=0, sum(total [Car sales]), Sum([Car production]))
file
in ur first expression; change it from
count(distinct [Line Desc 1])
to:
if(Dimensionality()=0,Count( total Distinct {<AccountDesc>}[Item-Branch Key]), count(distinct [Line Desc 1]))
result:
Thanks Omar , its working fine..