Jump to content

Worksheet Report not showing summary column


Recommended Posts

I have so many problems with VW 2018.

It's so frustrating.

Here's my latest.

I'm trying to create a simple report that counts symbols, and summarizes them.

It's such a simple task, and it used to be so easy, but the new method does not work.

 

Here's my initial report setup.

5a5144308f3be_worksheet2.thumb.jpg.54270194a7bcbdfa6c6de64cda0fe821.jpg

 

Then I make sure I have my criteria correct.

 

5a51442ee5369_worksheet1.thumb.jpg.bddd0725853f46d48e6a346b4cda1739.jpg

 

And this is what I get (note above image shows a different class, but it's from another report)

 

5a514422b8710_reportcountnototal.thumb.jpg.c1eb34379ef1100189264c1db03e9f14.jpg

 

Note the missing column of the summary total.

 

Did I do something wrong?

This is supposed to be easy.

 

 

Link to comment
  • 2 weeks later...
On 1/9/2018 at 4:09 AM, Markvl said:

I think what you need @Mickeyis the function "=count".  All you are asking for is the symbol name.  The spread sheet is not smart.  You need to tell it what you want to see.

Let us know how it goes.

:|

I find this extra step offensive since I clicked "summarize" in the initial setup then you think it would...   well...  SUMMARIZE.

I finally figured out how to add "count"

functions.thumb.jpg.9070004fef61cf6ee1752a9f9a115b2c.jpg

And Now I get a value of 1

5a663926703b3_nosummary.thumb.jpg.a0202fa6e7046d342f3035e37f28099f.jpg

 

So dear VW users I ask.

WTF!

There are far more than 1 of each light.

 

 

 

 

 

Link to comment

@MickeyCan you in anyway make the file small enough or perhaps make a new file and dump a few symbols and your worksheet into it and post it here for any to have  a look at?

 

I understand it gets frustrating at times.  There is an answer though.

 

In cell B2 you simply put       =count     

In cell A2 you want to "summarize items"                 right click while hovering over the small white box in the bottom right of the cell

in cell B2 you want "sum values"

Edited by Markvl
Link to comment
51 minutes ago, Markvl said:

@MickeyCan you in anyway make the file small enough or perhaps make a new file and dump a few symbols and your worksheet into it and post it here for any to have  a look at?

 

I understand it gets frustrating at times.  There is an answer though.

 

In cell B2 you simply put       =count     

In cell A2 you want to "summarize items"                 right click while hovering over the small white box in the bottom right of the cell

in cell B2 you want "sum values"

Wow that's incredibly stupid and complicated for what used to take me 4-5 clicks.

I created a new one, and got it to count correctly.

Thank you for helping with that.

 

Link to comment
  • 3 weeks later...
  • 1 month later...
  • 10 months later...

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.

×
×
  • Create New...