Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group by Aggregate

Hi everyone  I am required to have a group by total in my report. There are several rows of same supplier with different invoices total, I want to group all rows into one row and show the sum of in...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    You can write measure like below:-

    Measure_LT_125 = if(sum(total amount)<125000,sum(total amount))
    Measure_GT_700 = if(sum(total amount)>700000,sum(total amount))
    Measure_BT = if(AND(sum(total amount)>125000,sum(total amount)<700000),sum(total amount))
Watsky's avatar
Watsky
Solution Sage
4 years ago

Hey Anonymous ,

If your example isn't what you want it to look like, then can you show us what you want the results to look like?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Watsky

Thankyou for correction. Here is a new example how i want it to be look like  

Explanation ::: Sevenstar has many rows, I want it to be groupped in one row and show the total invoices and total .

 

Best regards