Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I Need to Calculate the percentage of each column on the totals of each rows.
In other words, I show you the table :
I'd like to obtain, for each rows, this value:
Totals | Column1 | Column2 | Column3 | Column4 | ||
---|---|---|---|---|---|---|
30/12/2014 | 552.687.882 | 478.734.685 / 552.687.882 | 28.035.992 / 552.687.882 |
| 1.890.400 / 552.687.882 | |
31/03/2015 | 747.808.949 | 676.981.625 / 747.808.949 | and so on.... |
To obtain this, I've tried with set analysis to ignore the dimension column in this way:
Count([Misure1]) / Count({$<dimension= >}[Misure1])
But it doesn't work. Can someone help me?
Try this:
Count([Misure1]) / Count({$<dimension= >} TOTAL <Data> [Misure1])
Thank you Sunny for the response, but in this way it returns all zero value
Would you be able to share a sample where this isn't working for you?
Yes, I can show you my specific situation:
I have a "Radio Button element" (bi-era.com-listbox is the name of the extension) that allows me to select a list of dimensions. The table has two dimensions: Data and Dim1 that is a varaiable and changes depending on the item selection.
I attached an image that shows the table and the Radio Box Element:
In the table properties, in added
Dim1 is so defined:
Load * Inline [
Display, Dim1
'Dimension X','xxx'
'Dimension Y','yyy'
'Dimension W', 'www'
];
So, I tried to write the expression that you suggested, in this way:
Count([Misure1]) / Count( {$< $(='[' & only(Dim1) & ']')= >} TOTAL <Data> [Misure1])
But it doesn't work, and i'm not sure the code is written in the right way.
Can you help me?
You want to see the percentage as this, right?
458,228,652
/
527,815,510
If this is what you want, I am not sure why it doesn't work. May be you are looking for this (but not sure)
Count([Misure1]) / Count(TOTAL <$(='[' & only(Dim1) & ']')> [Misure1])
Try this:
num(Count([Misure1]) / Count({$<dimension= >}[Misure1]) ,'#,##0%')
Regards,
Dixit Panchal