rows to coloum

[Anonymous]

Hi,

I have  a file called kpicategory with childcare, control, efficinecy .. (5 values) i need this 5 values as column values now..

I want to take this in straight table..  i know we can rearrage the column in pivot but i need this in pivot for other calculation purpose i need in straight table

Now:

KPI_Category
Child Care
Control
Disease Prev
Efficiency
Mortality

I need it as :

KPICategory

child care   control disease prev efficinet mortalily .

I want to take this in straight table..  i know we can rearrage the column in pivot but i need this in pivot for other calculation purpose i need in straight table

[Anonymous]

please see my below response

[Anonymous]

any help?

[kaushiknsolanki · Accepted solution]

Check this.

Regards,

Kaushik Solanki

[Anonymous]

thanks but i dont need the sum(num / deno) because it is taking the total sum for these numerator n denominator i only need count of num & demo whose values is greater than target

could you please find this?

[kaushiknsolanki]

Hi,

You can use this expression.

If(NUMDEN > Target,Count(KPIID))

Regards,

Kaushik Solanki

[Anonymous]

not exaclty the solution but i found a way

thnx

[kaushiknsolanki]

Great!

Please share what you did so that other community members who face same problem, can get help from what you found.

Regards,

Kaushik Solanki