1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How can I make a KPI for a single value?

https://preview.redd.it/1eighaiab4yg1.png?width=712&format=png&auto=webp&s=80a5c2912e18525e0322da4b81e8715cd39f94ff

Here's the context for the question:

  • I have a table/dataset covering a scenario where a company is tracking a set of products, with the products having sub-categories and normal categories.
  • It tracks order quantity, unit cost and unit price, as well as profit, cost and revenue for that sale already.
  • There's also some misc customer details but those are unimportant.

So now I have to make KPI Cards for the fields as shown in the picture.

But there's no measurements or absolute values or anything I can compare them too.
It's literally just this. Make a KPI card for 1 field with no details.

As far as I can tell it isn't even talking about "sub categories" or individual product types either. For all other questions those have been specified explicitly. And they've explicitly said in another part that they want KPI cards from PowerPivot, not a PivotTable or a just custom KPI or tracker for each value.

Been stuck on this for weeks.

submitted by /u/StrawberryFun7389
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#large dataset processing
#Excel alternatives
#KPI
#KPI cards
#PowerPivot
#dataset
#order quantity
#unit cost
#unit price
#profit
#cost
#revenue
#tracking
#products