St.aggrid Pivot table did not show the sale value/sum of vale value in detail area

Using Streamlit
, ,
1

dear BossI have implemented a pivot table using st.aggrid, which functions correctly with my Excel data. However, it fails to display the sum for the sales value in the column labeled “value.” All other options work properly, showing all fields with grouping functions and pivot fields, but the sum for the “value” column is not appearing as expected in the pivot rows and columns. I have highlighted this issue in the image below. Please review my code along with the result image and provide me with the correct code. Thank you in advance for your assistance.

see my code

import streamlit as st
import pandas as pd
from st_aggrid import AgGrid, GridOptionsBuilder, JsCode

data = pd.read_excel(“C:/mfa/export.xlsx”)

gb = GridOptionsBuilder()

gb.configure_default_column(resizable=True,filterable=True,sortable=True,editable=False,)

gb.configure_column(field=“value”,header_name=“Value”,width=100,
type=[“numericColumn”,“numberColumnFilter”,“customNumericFormat”],
precision=0,aggFunc=‘sum’)

gb.configure_column(field=“subType”,header_name=“subType”,
width=100,tooltipField=“SubType”,rowGroup=True,hide=True)

gb.configure_column(field=“variable”,header_name=“variable”,
width=100,tooltipField=“variable”,rowGroup=True,)

gb.configure_column(field=“virtualMonth”,header_name=“SDate”,
width=100,pivot=True)

gb.configure_grid_options(tooltipShowDelay=0, pivotMode=True,
allow_unsafe_jscode=True, groupDefaultExpanded = -1,
alwaysShowHorizontalScroll = True, enableRangeSelection=True,
pagination=True, paginationPageSize=10000)

g_opt = gb.build()

AgGrid(data, gridOptions=g_opt, height = 800, allow_unsafe_jscode=True)

see picture

image
image729×819 58.4 KB

2

I have the exact same issue! I was trying this with the example data (which you seem to be doing as well and it worked fine, but when I try it out with my data (which doesn’t have dates of any kind) I get the same issue as above.