BusinessCurrencyRegionTypeAmountAUSDMid AtlanticRevenue8BUSDMid AtlanticExpense3CCADTorontoRevenue7DCADTorontoExpense5 I am trying to split out the amount column into (2) columns - One for Revenue and One for Expense. Can somebody please assist? I appreciate the help,

Need help creating a pivot table with Summarize tool

I am trying to split out the amount column into (2) columns - One for Revenue and One for Expense.

Can somebody please assist?

I appreciate the help,

Datasets

Have you tried the Crosstab?

pivot with crosstab.png

@alexnajm I am not familiar with this tool. How would I configure to break out the amount column into 2 columns by type?

@CDIns screenshot has been posted - you can play around with the groupings if you need it to aggregate differently!

@alexnajm sorry, your screenshot did not load initially. Let me take a look and see if this works - thank you for the suggestion.

No worries @CDIns ~