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

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.

    • YJ's avatar
      YJ
      Icon for Resolver II rankResolver II
      6 years ago

      Go to visualization, under values of the column you do ot want the totals, click on the drop down and select "Dont summarise"

       

      regards

      SK