Date in Cross Tab

[kmontoya]

Hi,

My cross Tab data is coming out as below however I want all of the data with the same date to be summed together. Does anyone know how to do that?

Thank you!  

[rfoster7]

Can't really help you without some more inormation. 

In your workflow you didn't package in the input file so we can't look at the data. 

however, in your cross tab you are grouping by date, item and entity

So if you want it aggregated by date, you need to uncheck the other two items. 

[gautiergodard]

Agree with @rfoster7 its a bit hard to help without the underlying data.

From what I see, another way to solution could be to perform the aggregation before the cross tab, using a summarize tool. 

Once the data aggregated, could pass it through to the cross tab and finish your workflow.

[kmontoya]

Hi - sorry I'm not sure how to get the input data, but I've attached an excel here. I want my data to come out similar to the pivot table where some cash flows are getting filtered out (in this case the Bond/Interest). In this example I only have two items getting filtered out but is there a way to get multiple items filtered out without using the filter function? I find that when I write a big formula it doesn't actually filter anything. & the dates are collapsed as one. 

Thank you!! 

[gautiergodard · Accepted solution]

This would be a possible solution (attached).

Please like this post and mark this post as resolved if this helped!