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

[vinieme12]

Anil, 

You can summarize data by week /year / month or YTD but you have not provided that data in your inline table !

Provide a data sample that has data for all the dimensions that you will be using.

[Anil_Babu_Samineni]

Vinneth,

I got that.

So now my task is, I want to create one more expression with TOTAL and the total should be right side. Can you please have a look which i attach the image.

I Apologize my English. So , here i want to show only one column which is TOTAL. That also need Week, YTD with the whole WEEK data of each P_Des. For ref, PFA of image. Same as YTD also

[vinieme12]

Attaching a sample ; this is ideally how your data should be in order to achieve the given result.

I've produced auto generated data to create the given sample. as your inline tables have no relation to each other and neither do they provide any week or ytd info to work with.

Going forward please provide some sample data that replicates your data to be used, to work with so people her could help you better.

[Anil_Babu_Samineni]

Can you please have a look which i send my previous image. Upto that client accepting. But she want to add one more measure which name called TOTAL. For ref PFA

Here, How to calculate those total weeks into one part(Sum of Weeks)

[vinieme12]

Please see the APP, and the Image it has the totals where you want them

[Anil_Babu_Samineni]

There is no data. Is there any chance to share the first image App. Might be this task similar to first image. Please share me that App

[vinieme12 · Accepted solution]

sorry wrong app attached earlier

[Anil_Babu_Samineni]

This Time, I didn't get anything.

[vinieme12]

Your RAM is full, free some Ram, this is just 100 rows of data

[Anil_Babu_Samineni]

How to increase the RAM?