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]

I didn't give Partial Sums for Synthetic Dimension, I check only for Description Dim.

[vinieme12]

Anil,

Remove / eliminate your manual dimension or move it to the Top so Partial Sums for P_DES can take effect.

That will give you totals on the right(for which you have to select total at bottom).

To have Totals to Right(Totals at bottom) or Left(Totals on top) of the Pivot, you need to enable partials sums for the dimensions you drag to headers.

Partial Sums are not possible for Dimensions created using valuelist (Synthetic Dimensions)

[Anil_Babu_Samineni]

Here, I removed that manual dimension. Here, What i need to take the expression.

Dim are C_DESCRIPTION & P_Des

Expression is this

If(ValueList('WEEK','YTD')='WEEK',

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

If(ValueList('WEEK','YTD')='YTD',

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

[vinieme12]

Is it not evaluating?

[Anil_Babu_Samineni]

Yes, This is not evaluating proper way, It showing nothing.

[vinieme12]

Now that you've taken off your Manual dimension, you can also take of the below from your Expression

If(ValueList('WEEK','YTD')='WEEK',

only use

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

[vinieme12]

Uncheck / check Partial sums for each dimension and try subtotals at Bottom and top for both to see how the TOTAL moves

[Anil_Babu_Samineni]

Vineeth,

Did you see my image. I want to show Week and YTD as well

[vinieme12]

With the sample you provided, it's not possbile. Your data for Week and YTD isn't associated to your FACTS, that you want to summarize.

Please provide a a sample that is closest to your scenario and associated.

so we can use real dimensions, not created using valuelist; only then can we achieve your desired chart.

[Anil_Babu_Samineni]

I just created inline only.

LOAD * INLINE [

    C_DESCRIPTION, S_COUNT

    Reportable, 30

    Restricted work case, 2

    Lost Work Cases, 3

    Lost Days, 4

    Near Miss, 5

    RD, 6

    Man-Hours Weokec, 7

    Way to Work, 8

    Fire case, 9

    Environmental, 10

    External Firm, 11

    First and case, 12

    Collision/Nip point, 13

    Fall/Stubmling, 14

    Chemical contact, 15

    Electric shock, 16

    Thermal shock, 17

    Handling, 18

    Glass Thorn, 19

    Others, 20

    Technical, 21

    Organizational, 22

    Behavioral, 23

    Planned Corrective, 24

];

LOAD * Inline [

  P_Des

  All Plants

  Battice

  Birkeland

  EPAD/Brussels

  GOA

  EPAD

];

This is which i have, Anyway - I am so happy to close this issue. Now, I don't have the data model of Weak and YTD. So, is this possible then show me or else i can close this thread.

Because, My client task asking me to create for like below.