Only show totals in straight table

[#1]

Hi All,

Is there a way to only show the total in straight table?

Thank you in advance

[MK_QSL]

Yes... consider that you have Customer vs Sales data in your data model..

create a straight table without any dimension and use expression as SUM(Sales)  and label it as TotalSales...

[its_anandrjs]

Write Total with Expression

Sum(Total Sales)

Or

Sum(Total YourMetricNameHere )

Regards

Anand

[#4]

Hi Both,

Thank you for your response,

Perhaps if I explain in more details.

I have a project ID, date created. I wanted to know how many days it had been created then total the number of projectIDs that had been created for 180+ days.

This is where I have got to so far

To calculate the second column I did-

Interval((Date(Today()))- (sum(Created)), 'd')

To calculate the last column I did-

If(Interval((Date(Today()))- (sum(Created)), 'd')>180, 1, 0)

However I only want one box showing the total number of Product IDs over 180 days old.

Thank you!

[MK_QSL · Accepted solution]

=SUM(IF(Aggr(Interval(Today()-Created,'d'),[Project ID])>=180,1,0))

[#6]

You are a genius!!!

Thank you very much!