cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
deeksha Frequent Visitor
Frequent Visitor

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 for the measur

7 REPLIES 7

Re: Remove total from the measure

Hi,

 

You can disable the total in the visualization objects you are using. For examle, in a matriz:

 

Capture2.PNG

 

If it helps, pls give a kudo and mark as the solution. Thanks

 

 

deeksha Frequent Visitor
Frequent Visitor

Re: Remove total from the measure

but there is no option of subTotals.

Re: Remove total from the measure

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 Frequent Visitor
Frequent Visitor

Re: Remove total from the measure

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.

Community Support Team
Community Support Team

Re: Remove total from the measure

Hi @deeksha ,

 

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

2-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
deeksha Frequent Visitor
Frequent Visitor

Re: Remove total from the measure

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 Regular Visitor
Regular Visitor

Re: Remove total from the measure

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 336 members 3,146 guests
Please welcome our newest community members: