LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dunkleym

Hi All

I am trying to create a pivot table from data


Code Code Description
Code - A Desctiption - A
Code - A Desctiption - A
Code - A Description - A
Code - B Desctiption - B
Code - B Desctiption - B
Code - C Description - C

I want it to output with The Description and count of the Description .

any ideas please?? I haven't been able to get it to work.

Regards

Matt

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

To get a count, you can use the Histogram node.
Attachments:
histogram.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dunkleym

thanks Ryeh

is there a way to use the histogram to "SUM"?

Code Quantity
Code - A 1.58
Code - A 3.2
Code - A 1.0
Code - B 2.0
Code - B 3.0
Code - C 1.0

To output to

Code A - 5.78
Code B - 5.0
Code C - 1.0

thanks in advance

Matt

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

I would use Agg Ex or Quick Stats for that.
Attachments:
totals.brg