please share the .twbx and give more explanation.
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
Thanks you so much...
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.
Can you please share your .twbx file
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
also you please tell me how can I learn these calculation??
window_max blah blah