Calculate measures from dataset

[prat121]

from this given below dataset how can i calculate the measures like 

Account Payable

Account Receivables

COGS

Days Sales Outstanding

Gross Profit

Inventory

Inventory Days

Manpower Cost

Net Profit

Operation Cost

Operation Expenses

PBIT

Revenue

ROCE

Total Cost

Transportation Cost

Working Capital

Sr. No

Business Unit

Division

Plant

Material Group

Product2

Vendor_Customer

Purchasing Organization

Bucket

Date

Measure Name

Value

Goal

1

BU 1

Div 1

Plant 1

Mrp Grp 1

Product 1

Customer 1

Org 1

Jan-09

Revenue

1850

3975

2

BU 2

Div 2

Plant 1

Mrp Grp 1

Product 2

Customer 2

Org 2

Jan-09

Revenue

5656

4621

3

BU 3

Div 3

Plant 1

Mrp Grp 1

Product 3

Customer 3

Org 3

Jan-09

Revenue

5434

1627

4

BU 1

Div 4

Plant 1

Mrp Grp 2

Product 4

Customer 4

Org 4

Jan-09

Revenue

2947

2445

5

BU 2

Div 5

Plant 2

Mrp Grp 2

Product 5

Customer 5

Org 5

Jan-09

Revenue

1974

3287

6

BU 3

Div 6

Plant 2

Mrp Grp 3

Product 6

Customer 6

Org 6

Jan-09

Revenue

3905

2269

7

BU 1

Div 1

Plant 2

Mrp Grp 3

Product 7

Customer 7

Org 7

Jan-09

Revenue

4786

2925

8

BU 2

Div 2

Plant 2

Mrp Grp 4

Product 8

Customer 8

Org 8

Jan-09

Revenue

4413

3107

9

BU 3

Div 3

Plant 3

Mrp Grp 4

Product 9

Customer 9

Org 9

Jan-09

Revenue

2566

1913

please help me to solve this 

[Tanish]

Hi @prat121 ,

Your dataset is not fully visible can u share excel file instead of this.

How to do want these measure do you want show these in KPI or in any other way and mostly client provide formulas which is to be used for creating such measures.

[prat121]

yes i would like to show in the KPI and also i have been given an assignment so i would like to calculate all the values.

[Tanish]

Hi @prat121 ,

You can use this expression under KPI

Sum ({<[Measure Name] = {'Revenue'}>}  Value)

Sum ({<[Measure Name] = {'Account Payable'}>}  Value)

like this way you can create all the KPIs, same exp. every time just need to change Measure Name.

Hope this will help...

Thanks,

Tanish 

[prat121]

hello tanish, this is what i have been doing but i have been getting different values for these measures, I have been provided with an wireframe and it is not matching it.