Can we have common column header for multiple columns. For example, we have same entity name for different columns, and we want to merge and center those column headers for multiple columns. Below is the attached cube view and desired output image.
Any solution to this will be very helpful and thankful.
In PDF Reports this works like you want, as long as you have one column with two nested dimensions, e.g.
In Data Explorer, on the Entity header you will get two separate cells but only one of them will contain text.
In Excel unfortunately you will get full separate headers.
This is unfortunately a common issue. You might want to upvote (kudo) this IdeaStream post: