Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can I create table like following sample? Third row has Expression = (row2-row1) / row 1
It's easy to do this in column. How do I do it in row?
My dimension is Year. Each column is the measure of the type.
Thanks
Regards
I-Cheng
Hi,
Please refer to attached sample mock. let me know if still not working.
Hi,
Yea it can be done.
Just use like below,
(Column(2)-Column(1))/Column(1)
or
create two calculated dimensions as 2016 and 2017 then
=((cal.dim2016) - (cal.dim2017))/ (cal.dim2017))
Hope this helps you
Regards,
Deva
Hi,
Please refer to attached sample mock. let me know if still not working.
Hi Deva,
Thanks a lot for the tip. The Dimensionality() function for the scenario is a neat approach.
Do you know if there's way we can set the '(%)Change' in the bottom? For straight table you can specify "Total" position. I can't find corresponding attribute in Pivot table.
Thanks
Regards
I-Cheng
Hi,,
Yeah both table & pivot table can be done, please refer to the attachment.
using table view u can put the total in bottom of u r report (u need to paste u r expression under presentation tab --> Total field (refer below screen shot).
note: pivot table we can't put the total in below (there tool default chart limitation).
i would suggest you go for Pivot table option.
Hope this helps you
if your issue resolved, help to close this thread by marking correct/helpful. Tks
Regards,
Deva
Hi Deva,
Appreciate your help! Pivot table is more close to what I need to present.
I am unable to use straight table to make "Total" work. I have more than one measures and each with different criteria.
Although straight table can show "Total" in bottom.
Thanks a lot!
Regards
I-Cheng