We want to display a tabular view with single measure field (“budget revenue”) with a pivot dimension as (“Budget Name” -> ALL, APAC, NAR etc). As we see in the screenshot, the single measure field (“budget revenue”) is repeated for all values of the pivoted dimension column. Here the name “budget revenue” is too much repeated.
Instead we would like to display same tabular view but without duplicating the “budget revenue” in each column. (something like swapping the positions of measure field and pivot names, so that measure filed name is shown only once.).
Is there a way to achieve the same?