Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, We have a requirement as to display the value of column only once . Could you please let me know how to avoid repetitive values. Auto should be displayed only once under customer Vertical.
Customer Vertical | year | Tatal amount |
Auto | 2016 | 100k |
Auto | 2017 | 200k |
Auto | 2018 | 250k |
Auto | 2019 | 400k |
Auto | 2020 | 500k |
Did you try creating pivot table? Pivot table shows values once.
would you be able to share sample?
Customer Vertical | year | Tatal amount |
Auto | 2016 | 100k |
2017 | 200k | |
2018 | 250k | |
2019 | 400k | |
2020 | 500k | |
This is how i want to display.
i am Also Having same concern