•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?
Our take
Creating a KPI card for a single value can seem challenging, especially when specific comparisons or measurements are absent. In your scenario, where a dataset tracks product order quantities, unit costs, and profits without clear benchmarks, focus on the key metric you want to highlight. Utilize PowerPivot to extract and visualize this data effectively. By selecting a relevant field—such as total profit or revenue—you can create a powerful KPI card that conveys essential insights at a glance, driving awareness and informed decision-making.
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]
Read on the original site
Open the publisher's page for the full experience
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