In qliksense we create a pivot table So in that pivot table we on Totals so if we On Show Totals then what happens it applies to all as you can see be

[BhaminiParmar12]

In qliksense we create a pivot table So in that pivot table we on Totals
so if we On Show Totals then what happens it applies to all as you can see below my pivot table

so what do I want is that My Profit should not show totals value I should show AVG value

Data:
LOAD
"Row ID",
"Order ID",
"Order Date",
"Ship Date",
"Ship Mode",
"Customer ID",
"Customer Name",
Segment,
City,
State,
Country,
"Postal Code",
Market,
Region,
"Product ID",
Category,
"Sub-Category",
"Product Name",
Sales,
Quantity,
Discount,
Profit,
"Shipping Cost",
"Order Priority"
FROM [lib://Data Source/ECOMM DATA.xlsx]
(ooxml, embedded labels, table is Orders);

Data2:
Load * Inline [
Dim1, Dim2
ID, "Row ID",
ID, "Order ID"
ID, "Customer ID"
ID, "Product ID"

Product,Segment
Product,Category
Product,Region

INR,Profit
INR,Sales
]

so what is the solution for this to get Avg value of Profit in Pivot Table in Qliksense

[lennart_mo]

I'm guessing you want to display the Average only in the first row for your Profit-Column, right?

In that case you'll need to use Dimensionality().

Altering your expression to something like

=if(Dimensionality()=0, Avg(AGGR(Profit, Region, Dim2)), Profit)

 should work.