Pivot Dimension

[Anil_Babu_Samineni]

Hello,

I am trying to take calculated dimension with exclude values

LOAD * Inline [

  P_Des

  All Plants

  Battice

  Birkeland

  EPAD/Brussels

  GOA

  EPAD

];

Here,

1) I want to exclude All Plants & EPAD

2) Is it possible to move that Total values into Right part with last column. This is Pivot Table only.

- ANIL

[Anil_Babu_Samineni]

There is no images. If you see any thing please share me with Attachment.

[Anil_Babu_Samineni]

Sure Sunny,

PFA

Here, I want to do exclude only All Plants and EPAD

[Anil_Babu_Samineni]

In this expression,

I don't have sub fields. I just take the ValueList for Week and YTD

[sunny_talwar]

Would copy and pasting your expression an option?

[Anil_Babu_Samineni]

Can you plz have a look. I already attached which you asked for ref

[mightyqlikers]

hi,

in the attached sample there is no relation between two tables.

how u are expecting values in pivot table.

what actually you want.

$@M.              

[Anil_Babu_Samineni]

I am creating Pivot Table only, This application no need to check the Data model as per my experience.

PFA of Updated one, Please?

I am expecting the fields not the data and meantime, i am not sure this question - How to move that total to Last Column?

Might be this is not a make sense. But, I need to know whether it is moving or not..

[vinieme12]

See Attached, look at presentation tab

[Anil_Babu_Samineni]

I don;t think so, Is that is workable, Because, I need to filter only four values which i got the output.

Can you please let me know what i need to change here, Why are you using below expression instead of my expression

My expression is Wrong?

pick(match(ValueList('WEEK','YTD'),'WEEK','YTD')

,sum(aggr (NODISTINCT Sum({<C_DESCRIPTION = {'Reportable','Lost Days','Restricted work case','Near Miss'}>} S_COUNT),C_DESCRIPTION))

,sum(aggr(NODISTINCT Sum({<C_DESCRIPTION = {'Reportable','Lost Days','Restricted work case','Near Miss'}>} S_COUNT),C_DESCRIPTION))

  )

[vinieme12]

Partial sums don't work for Synthetic dimensions created using value list. Load Your Week / Year values in a dimension in your load script. If you change the Order and Move "Manual" above P_Des, you will see the TOTALS on the right