query on Straight table( to show all dimension irrespective of expression)

[#1]

Hi,

I am having two tables X & Y.

and

I want to display a straight table with Name and Sum(sales) with Region filter as 'India'.

Below displays the required chart. I want to display last row also.

Please Suggest.

Regards,

Joshmi

[Anonymous]

For the dimension Tick Show All Values.

On the Presentation tab untick Suppress Zero-Values and Suppress Missing.

[#3]

Hi Bill,

Thank You for your Reply.

I have tried the same.

But In this case last row which is having 0 sales is not displaying.

I want to display that row also.

Regards,

Joshmi

[Anonymous]

Strange, it seems to work for me,

See attached.

[Anonymous]

Here in this pivot table i m having the issue with the Performance Total it is varying .

It should be Sum([Coperate SLP])*[Performance])

Means (103*106)+(0*111)=109.18 but its displaying as 111 that is the problem over here.

Please Help me guys since a week i m striving to get it done but its not getting perfect.

[#6]

Hi Bill,

Thank You for Your help. This is working.

Could you check for 1 more scenario.?

if the 2nd table is like below,

If I am selecting Date: 19/12/2014, I should get the previous Result.

Regards,

Joshmi

[Anonymous]

Hi i m having a query in pivot table can u help me ...

bunnyqlik@gmail.com

[Anonymous]

Joshmi

The etiquette is one question per thread.

So for your new question probably best to create a new thread for it.