OWC 11 - Show top botton items

[Lucas]

Hi,

I'm using OWC and I found that the feature Show Top/Bottom Items counts the
Empty rows. I have unchecked the option Always display - Empty Rows but this
feature take them into account. The big problem is that Show Bottom doesn't
give me any data because the empty rows are at the bottom.

Is there any solution to this issue?

Thanks a lot

LucasC

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

I'd suggest you may test the second sample of pivottable from OWC toolkit for this issue. Please select the "New OWC features" in the left panel of
owc tool kit UI, click "PivotTable List Demonstration". After that, one IE window will pop up. Select the "next" button twice. Then one Pivottable
sample appears. I test the show top and bottom in this sample. All the result contains the correct rows with one summarization row.

For the implementation, you can check the javascript source code for this. The source code for this sample is in the PTDemo.htm page which is
located in the directory:
%ProgramFiles%\Office Component Toolpack\Walkthroughs\Pages

In the file, there is one iStep variable which contains the step number for customer click number on the "Next" button. The "stepNext" function
contains one swich sentence to display the corresponding sample. You will find the sample2-related functions in the "case 2" of the swtich sentence
which may provide some assistance for you on this issue.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Lucas]

The Show Top/Bottom seems to be a feature of OWC 11, is necessary to add
custom code in order to avoid Show Bottom take null rows into account? Does
not pivot table solve this correctly?

Using OWC Toolkit/New OWC Features/Pivot Table List Demonstration/TopN
Bottom N Filtering.

Here the example: Put "Country" and "Customers_CompanyName" dimensions in
Rows Area; put "Sales" measure in Data Area;

As you can see "Argentina" has more than two members with value (exactly 3).
Making a Bottom 20 by "Customers_CompanyName" dimension, with de Display
Empty Rows checked, you can see 20 members with or without value. Also if
you make a bottom 2 in the same dimension, it returns the last 2 members (in
this case null values).

But if you uncheck "Display Empty Rows" (Pivot Table must show just Rows
with some value), if you show Bottom 2 Pivot Table doesn't show me any row
for Argentina. That's because the Bottom feature is showing the last 2
elements without taking account if those members must be shown (because
their rows has empty values).

I think it must show me the Bottom elements of rows that match the Display
Empty Rows selection (just the ones that have any value).

LucasC

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

I'd suggest you may test the second sample of pivottable from OWC toolkit

for this issue. Please select the "New OWC features" in the left panel of

owc tool kit UI, click "PivotTable List Demonstration". After that, one IE

window will pop up. Select the "next" button twice. Then one Pivottable

sample appears. I test the show top and bottom in this sample. All the

result contains the correct rows with one summarization row.

For the implementation, you can check the javascript source code for this.

The source code for this sample is in the PTDemo.htm page which is

located in the directory:
%ProgramFiles%\Office Component Toolpack\Walkthroughs\Pages

In the file, there is one iStep variable which contains the step number

for customer click number on the "Next" button. The "stepNext" function

contains one swich sentence to display the corresponding sample. You will

find the sample2-related functions in the "case 2" of the swtich sentence

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying and more information regarding this issue!

This is really the feature of pivottable. After reproduce the steps according your post and from my experience, this is by design. However, this is a
great idea for a future product enhancement. I'd recommend that you forward the recommendation to the Microsoft Wish Program:
1. World Wide Web
a)In Internet Explorer 6, click Send Feedback on the Help menu and then click the link in the Product Suggestion section of the page that
appears.
b)In Windows XP, click Help and Support on the Start menu. Click Send your feedback to Microsoft, and then fill out the Product Suggestion page
that appears.
c)Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm
d)Click Microsoft.com Guide in the upper-right corner of the page and then click Contact Us . Click the link in the Product Suggestion section of
the page that appears.
e)Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.

2. E-mail - To send comments or suggestions via e-mail, use the following Microsoft Wish Program e-mail address, (e-mail address removed).

3. FAX - To send comments or suggestions via FAX, use the following Microsoft FAX number, (425) 936-7329.
NOTE : Address the FAX to the attention of the Microsoft Wish Program.

4. US Mail - To send comments or suggestions via US Mail, use the following Microsoft mailing address:
Microsoft Corporation
Attn. Microsoft Wish Program
One Microsoft Way
Redmond, WA 98052-6399

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.