Straight Tables with Labels and Calculated Cells

[#1]

Hi,

How can I make a straight table (or an equivalent) that will be as such where one column is labels, and the other is calculated (without the parentheses):

Number of customers	25 (actual code is "=count(customers)")
Sum of Sales	$37,569 (actual code is "=sum(sales)")
Average of sales	$56 (actual code is "=avg(sales)")

Thanks!

[alexandros17]

Use a pivot table without dimensions and 3 expression having your formulas ...

let me know

[Anonymous]

Hi!

Take a look on the attached file.

Regards,

Gabriel

[jonathandienst · Accepted solution]

Hi

Just create a normal straight table with no dimensions and multiple expressions. Then in Properties | Presentation, check the Horizontal check box. You will want to turn off the totals for the expressions as well.

HTH

Jonathan

[#5]

Thanks!

As always, it's amazing how fast this community works