Jump to content

Exporting summary fields only


Recommended Posts

Hello all, 

I have an embarrassingly simple question but I can't find the answer to it:

Let's say I have single-table, single-layout file with 10 items. I have 1 A, 2 Bs, 3 Cs, 4 Ds. There is a summary field "itemcount" which does what it says. Sorting by "item" I get 

A
	1
B
B
	2
C
C
C
	3
D
D
D
D
	4

I want to to export the 4 itemcount fields as in:

1
2
3
4

So far with any permutation of the setting in the Sort and Export windows I get this:

10
10
10
10
10
10
10
10
10
10

What are the correct settings to achieve what I need?

Thanks

(PS: I may ned the "Complete Idiot's Guide" version, sorry...)

Link to post
Share on other sites

First, sort by the Item field (or whatever the field you want to group by is called). 

Then, in the 'Specify Field Order for Export', dialog, check the Group by [Item] option and add the Item field and the summary field to the field export order. At this point, the dialog will display:

image.png.94ac195e3a8c237c2a1a129e5a40cf4b.pngNow select the summary field only (leaving the 'sCount by Item' pseudo-field in place) and remove it from the field export order.

 

Edited by comment
  • Like 1
Link to post
Share on other sites

It took a while to realize that your instruction was to be taken very literally: FIRST you check the box and THEN you move the items. 

It worked. Thanks. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Who Viewed the Topic

    1 member has viewed this topic:
    noelteale 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.