Create Pivot Table without Dimension

[#1]

Hi, I want to create a pivot table with 3 column, which is sum(sales_count), sum(Sale_Target), and sum(sales_count)/sum(Sale_Target).

In this case, I don't want any dimension to appear, just the column name.

But the pivot table always show blank dimension. How to hide it?

Regards

Benjamin See

[er_mohit]

here for the dimension purpose which you want to get expression is also write in expression side like this way

Sum(TOTAL{$<Dimension1=,Dimension2= >}sales_count)  //for 1 column

Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target) //for 2 column

Sum(TOTAL{$<Dimension1=,Dimension2= >}sales_count)/Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target)  //for 3rd column

or without write total you can also do this like

Sum({$<Dimension1=,Dimension2= >}sales_count)  //for 1 column

Sum({$<Dimension1=,Dimension2= >}Sale_Target) //for 2 column

Sum({$<Dimension1=,Dimension2= >}sales_count)/Sum(TOTAL{$<Dimension1=,Dimension2= >}Sale_Target)  //for 3rd column

[hic]

The pivot table always has a place holder for the dimensions, yes. If you just want a one-liner with these three numbers, I suggest you create a straight table instead. You need to turn the Totals of to make it look nice (Expressions tab).

HIC

[#4]

hI, i had put in the expression, but still it showing the blank dimension (Pivot Table --> Expression -->Definition).

[#5]

Hi, when I use the straight table, even I put in =Sum(), it showing the list of number instead of the total.

[hic · Accepted solution]

Then you are using a table box, not a straight table. Create a chart and choose this:

HIC

[#7]

Dear HIC, thank you very much. It work.