Forum Discussion

deeksha's avatar
deeksha
Icon for Helper II rankHelper II
6 years ago

Remove total from the measure

Hi, I have created a measure to calculate the sales revenue, but I do not want the total in the report, and in the other measures too, i don't want the total in the report, How to remove the total f...
Need Help
deeksha's avatar
deeksha
Icon for Helper II rankHelper II
6 years ago

but there is no option of subTotals.

mauriciosotero's avatar
mauriciosotero
Icon for Resolver III rankResolver III
6 years ago

Hi,

 

Which visualization object are you using (chart, matrix, etc)? Did you click on it and navigate on the Visualization pane as I a shown and the last post?

  • deeksha's avatar
    deeksha
    Icon for Helper II rankHelper II
    6 years ago

    I am using a table, and I have created a field using measures and in that total is coming but I don't want total for that and there is no option for subtotal too.

    • v-eachen-msft's avatar
      v-eachen-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi deeksha ,

       

      You could find "total" option in the Format tab, turn it off.

       

      • deeksha's avatar
        deeksha
        Icon for Helper II rankHelper II
        6 years ago

        But I want Total for other columns, removing total will hide total for other columns too but I want to hide total only for the sales revenue column which I have created using the measures. So basically I want to hide total for a single column which I have created using measures and there is no subtotal option for that in visualization.