on 01-08-2015 10:15 PM
Hi all,
I have this table
The last colum (Max) is shows the max value from column Count.
Now I need to show the the max value (from any row as is the same for all of them) in a cell object. But when I do that get a 1 for the value because the Period is not used in the cell. So the aggregation is wrong.
Is there any way to solve this?
I tried using Max in Report but didn't work.
Thanks!
Finally solved it using cells in the Bex Query.
Thank you all for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pepe ,
Use count function for period to find the count like below:
=Count([Period]) In Report
Regards
Sheetal Sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Pepe,
try using Max([Count] ForEach ([Period]) ) In Report,
CHeers,
ROgerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.