Expressions between Dimensions in Pivot

[#1]

Original Pivot table

Goal

Hi,

I want to make the 1st picture (Original Pivot table) to the 2nd one (Goal), what should I do?

Blue columns are expressions and white ones are dimensions. Thx!

[Anonymous · Accepted solution]

You can create these columns as calculated dimensions instead of expressions.