Author Topic: pivot table with formula for different feilds  (Read 235 times)

hyh888

  • Pro Enterprise
  • Full Member
  • *
  • Posts: 128
    • View Profile
pivot table with formula for different feilds
« on: June 01, 2023, 06:45:20 pm »
After studied the demo for pivot, I wonder if pqgrid can add formula for different feilds, if it's possible, would you like to provid a sample?. In your demo the formula is for two years in one field which is not what I need.
I made a demo with excel pivot table in attachment, the formula column is marked with yellow,the growthrate column is formula column,growthrate=(qty/lastYearQty-1).
« Last Edit: June 01, 2023, 06:50:18 pm by hyh888 »