Sum data and group by variables

[Anahita]

 

I want to show sum(Amount) group by BGID and InsOfficeNodeID. and End user should select BranchName and BGName from a list. The problem is when BranchName is selected(for example ‘A’), the result is shown should be like this:
Sum(Amount) where : BranchName=’A’ and InsOfficeNodeID= ParentID
I don’t know how to do

[PrashantSangle]

Can you provide some sample data & expected result of it.

If your data model is same which you share in above image. then you just need to create straight table

with dimension > BGID, InsOfficeNodeID,

Expression: Sum(if(InsOfficeNodeID=ParentID,Amount,0))

Regards,

Prashant Sangle

[Anahita]

If I want to show sum(amount) when user select branchld, what should I do?

I’ve tried this but it doesn’t work.

sum({<FactRevenueAmt={“>=$(=branchId)”}>} Amount)

[Kushal_Chawda]

@Anahita  Can you create a sample data with expected output in excel?

[Anahita]

Here you are.

• 
  
  
•  

[Kushal_Chawda]

@Anahita  I don't see InsofficeID and ParentID in your excel data. Also, don't see expected output

[Anahita]

Instead of these 2 fields I want to use branchId, take, user choose one of the branchId, one of the group name , one or more month, so based on these fields sum(amount) should be displayed