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
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.

      • 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