Jump to content
DaveCarr

Different Worksheets not displaying the same data correctly

Recommended Posts

Hi All,

 

I am having an issue with one worksheet not showing the correct data.

Here is my example:

Worksheet 1 (displays all items correctly), Lists all stage deck items, Purpose, Size, and Height

Worksheet 2 (does not display the data correctly), Quantity of Stage Decks needed, Size, and Height

Worksheet one gives me 19 objects, 18 4x8 decks and 1 4x4 deck

Worksheet two gives me 19 objects, 19 4x8 decks

The Criteria on both is set to Type is Stage Deck and all the cells are set to the some record data.

My workaround is to manually add the one missing item

 

I've tryed coping the data headers from one to the other and no change.

 

Thank you!

Workshhet Data Issue.PNG

Share this post


Link to post

Can you post a file with everything but the stage decks and the worksheets stripped out?

Share this post


Link to post

Not sure I'm seeing the problem.

 

Maybe I'm looking in the wrong place, but it looks like both worksheet reports are seeing 19 platforms.

 

[Worksheet 1 B6] = 19 = [Worksheet 2 B3]

 

 

Share this post


Link to post

Thank you for looking at my file!

 

Yes both worksheets display 19 platforms. The problem is the individual platform counts.

 

Worksheet 1 (furniture) displays 4- 4x8 @2' and 15- 4x8 @ 3'

Worksheet 2 (staging) displays 1- 4x4 @ 2', 3- 4x8 @ 2', and 15- 4x8 @ 3'

 

If you look at the drawing worksheet 2 is correct. as far as i can see all the criteria are set the same. I tried copying the criteria from worksheet 2 to worksheet 1 and got the same wrong counting.

 

 

dcarr worksheet.vwx

Share this post


Link to post

Edit the header for Worksheet 1 and turn on the Summarize check box for column C. You will then get 3:15:1 4x8/4x8/4x4.

 

You now need to Summarize each column individually to make sure you get the right information.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...