•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I make a KPI for a single value?
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
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