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]

rebooting ur computer should help!

[Anil_Babu_Samineni]

I created same as you, But unfortunately - unknown field data also came.

Can i know what is that. How to remove that

[vinieme12]

Check - Suppress when value is null on your dimensions

[Anil_Babu_Samineni]

Check this, Almost reached. Let me know do i need to check the boxes

[vinieme12]

on your dimensions TAB select C_Description and below you will see Suppress null values check box

[Anil_Babu_Samineni]

Coming to script,

I dont have date field. I have only c_descriprion, p_des, s_count.

With out s_date. Is this same table possible.

Mean time, I have one date field with the format of mmm-yy. This case, I want to show weeks.

Date

Jan-2015

Feb-2015

....

Dec-2015

So, total I have 12 months fit 2015 year. I want to show weeks(52) of the 2015 year. What I need to create master calendar

[vinieme12]

If you do not have date how are you going to show week and YTD data?

[vinieme12]

Please share your data sample in all its completeness!!

[Anil_Babu_Samineni]

Data is very secure.

Anyway, I do have one date field. So, here I want to show the weeks like 52 in list box. How to show?

[vinieme12]

no need to post actual data!!, post a sample with dummy values as I have...