Is it possable to not show value if the same as the line above in table
Hi I have a report that I’m trying to create that will simply be exported to excel, the data is correct and exports fine but I have been asked if it cannot display the line if it is the same as the one above and just show the detail on the line. (It’s kind of hard to explain, see the picture below)
The top image is what I have and the bottom image is what they want.
Re: Is it possable to not show value if the same as the line above in table
Well, the first thing that comes to mind is to convert the chart from a Straight Table to a Pivot Table and that would ensure the proper grouping of the identical values.
If, however, you want to say with the Straight Table, I'd suggest to play with the Text Color attribute of the dimension. Try using finctions like ABOVE() to compare the current value with the previous value. When the values are identical, set the Text Color to transparent - ARGB(0,0,0,0).