Pivot chart with different level sub total?

[skumarqv11]

Hi Folks,

I need to create a pivot table in different way. I have attached the Excel file which has sample dataset and Pivot structure.

Also attaché the QVW file which I have created with simple pivot.

Can you please suggest me how to do that?

Please suggest if we have any different way to implement it?

Thanks,

Shravan

[vishsaggi]

Are you looking something like this?

If yes just use below as your expression in your table:

= IF(Dimensionality() = 2, Sum( {<BID={'N/A'}>} Value)&'/'&Sum( {<BID -={'N/A'}>} Value),sum(Value))

However, i would like to know if your BID will always have a value N/A. Let me know.

[skumarqv11]

Hi Vishwarath,

Thanks for your reply, But I need like below. I want to Ignore N/A from BID and Country.

My result should be like this.

Level=2 country result/ all BID Result.(150/90), Because I may have N/A or may not so.

All BID we can get that, But I am trying to get the value for Level=2 country.

I need a expression to get 150 value which is country level=2 value

[vishsaggi]

But your country level 2 has a BID with value 'N/A' right?

[vishsaggi]

Check this?

= IF(Dimensionality() = 2, Sum( {<BID -={'N/A'}>} Value)&'/'&Sum({< BID = {'N/A'} >}Value), sum(Value))

For Dim BID use like below and in the expr use the above and let me know.

[skumarqv11]

Hi Vishwarath,

Thanks for your reply.

Its like hierarchy concept. I have BID's values for Each country and Country also have different Value.

Here My case is I have a country value which is doesn't have BID (i.e. N/A here), Its a total country level value 150.

I have BID's in each country that is BID1,BID2,BID3 etc.

Each BID's having values.

My scenario is I want to compare the values like below.

Country Level Value/ sum of BID's in that Country (150/90).

There is difference in 150-90=60.

To check this N/A is the country level value, BID's each BID's value in the same Country.

[vishsaggi]

Sorry quite did not follow you, can you tell me what exactly you are expecting to see in your Pivot?