Jump to content
We've recently updated our Privacy Statement, available here. ×

Cross Table - Calculate difference between two columns


V S

Recommended Posts

Hi,

I have a cross table as follows -

 

 

 

 

ColumnA

ColumnB

ColumnC

 

 

Store Location

Category1

Category2

Category1

Category2

Category1

Category2

 

 

Boston

200

100

250

230

230

210

 

 

New York

180

150

310

270

240

220

 

 

Stockholm

190

140

180

160

220

210

 

 

London

170

140

340

310

420

380

 

 

 

I want to calculate the difference between two categories for each Columnsas follows -

 

 

 

 

ColumnA

ColumnA Diff

ColumnB

ColumnB Diff

ColumnC

ColumnC Diff

 

 

Store Location

Category1

Category2

 

Category1

Category2

 

Category1

Category2

 

 

 

Boston

200

100

100

250

230

20

230

210

20

 

 

New York

180

150

30

310

270

40

240

220

20

 

 

Stockholm

190

140

50

180

160

20

220

210

10

 

 

London

170

140

30

340

310

30

420

380

40

 

 

 

My horizontal axes expression is as follows -

[Axis.Default.Names] NEST [CategoryName]

What custom expression need to use to get it Appreciate any suggestions.

Thanks a lot.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...