Forum Discussion
Don't summarize values in table visual
Hi,
I have a table with a lot of detail in a visual.
The table in data section is ok, for example for column "No Pedido" I have 18 registered data as "001-07" as I show in the first image.
But when I create the table as a visual and applying "don't summarize" in all the collumns, some data is summarized, for example the "001-07 have just 15 records (as shown in the second image).
Thanks so much in advance
Hi eduardosilvin2 ,
The 'don't summarize' means that the field/column will not be aggregated (count, sum, first, last, etc) but will not stop other non-aggregated column from not being repeated like as shown in the data view. The workaround is to add a column with values that are always unique per row (values that don't repeat in any other rows) like an index column. Of course, I'd change the value color of the index column as well as that of the header so they blend with the background (eg white text on a white background).
2 Replies
Hi eduardosilvin2 ,
The 'don't summarize' means that the field/column will not be aggregated (count, sum, first, last, etc) but will not stop other non-aggregated column from not being repeated like as shown in the data view. The workaround is to add a column with values that are always unique per row (values that don't repeat in any other rows) like an index column. Of course, I'd change the value color of the index column as well as that of the header so they blend with the background (eg white text on a white background).
So simple and effective, thank you so much, not only gave me a solution but you explained it. Really appreciate it.
Regards
