Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
Please find attached.
so the Data looks as given.
I need to create a chart (below) that looks like the desired output. Hope you can assist!
Thanks
I presume that the first table you show is a table that is exactly like that in the Data Model as a data table and not a UI table having aggregates...
If so then simply create a UI regular table in a sheet:
1) Create a dimension with the field [Table]
2) Create a measure with the following expression: Count( [Table] )
And you will get what you asked for....
I presume that the first table you show is a table that is exactly like that in the Data Model as a data table and not a UI table having aggregates...
If so then simply create a UI regular table in a sheet:
1) Create a dimension with the field [Table]
2) Create a measure with the following expression: Count( [Table] )
And you will get what you asked for....
Hi,
create a straight or pivot table with dimension table and expression =aggr(count (cardno),table)