8 Replies Latest reply on Aug 9, 2018 8:20 PM by meenu choudhary

# Columns of a same dimension -manupulation

I want to subtract column 9 and grand total(calculated using max) ...urgent help

• ###### 1. Re: Columns of a same dimension -manupulation

Hi Manish,

please share the .twbx and give more explanation.

Cheers.

• ###### 2. Re: Columns of a same dimension -manupulation

Basically this is my official data I won't be able to share it with you:

but can share the screen shots

so, the problems is........ period is dimension and there are 9 levels to it

I want to create a column where I can subtract 9th columns value from maximum value( of all the periods) for a single row.

it would be great if we could subtract in one go

so firstly,

so the column grand total is not required if we could go as mentioned above

• ###### 3. Re: Columns of a same dimension -manupulation

Hi Manish,

I have created the above scenario using super store and below is the logic:

if ATTR([Order Priority])="High" then

WINDOW_MAX(sum([Sales])) -sum([Sales])

END

so, in your case you can replace,order priority with period,sales with the measure value and "High" with 9.

• ###### 4. Re: Columns of a same dimension -manupulation

Thanks you so much...

two things

how can I learn these type of calculation??

The output is also having other periods and when I keep only 9th period  the value calculated changes. I want to plot only 9th period and the calculated field.

thanks

• ###### 5. Re: Columns of a same dimension -manupulation

Hi Manish,

• ###### 6. Re: Columns of a same dimension -manupulation

Hi

I would have done that but thats on big query and id password is with the company.

but I can share cross tab csv of some extracted data

will that be fine

• ###### 7. Re: Columns of a same dimension -manupulation

also you please tell me how can I learn these calculation??

window_max blah blah

• ###### 8. Re: Columns of a same dimension -manupulation

Hi Manish,

Go through the below url, it will help you understand the basics

And yes,please share the sample csv .