23 Ağustos 2012 Perşembe 12:43
I realise this is probably the basic of basic fundamentals of powerpivot but need to get an answer quickly to convince a team this is worth using.
I have a pivot table based on 2 imported tables from a SQL DB, the pivot table displays count of logins, another on count of staff. I need to work out the % of staff who are logging in at each site.
The calculation (logincount/staffcount * 100) for each row. Do you know if i need to build this into the pivot table or if it needs to be external to the pivot, i have added to the adjacent cells external to the pivot and just reference the sales but i cannot copy the formulae down the whole set as i would normally in excel.
Can any one point me in the right direction.
23 Ağustos 2012 Perşembe 13:23What you want is a measure. Right-click the table in the PivotField List and create your formula there.
23 Ağustos 2012 Perşembe 13:26
yep worked it out
cool, with the slices to group it at any level, i is laughing.
- Yanıt Olarak İşaretleyen Elvis LongMicrosoft Contingent Staff, Moderator 30 Ağustos 2012 Perşembe 10:10