The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Please see the image below.
The formula Calc = Column_D / (Column_p - Column_F) needs to be applied to all rows. For Group totals (Level 1-5), this means the forumal should apply to the Sum of each one of these columns, attributable to rows rolling up to that level. Since Group totals are already calculated in Columns named D, I, P, and F , using sum(Field!.D.Value), can the last column somehow refer (reuse) those results? Can a single calculated Expression be used to poupulate the last column, based on the corresponding values on columns D, P, and F on the same row? Thank
@Ibrahim66 , refer if this can help
https://stackoverflow.com/questions/51401471/ssrs-adding-total-row-percentage-of-the-total
User | Count |
---|---|
69 | |
66 | |
62 | |
48 | |
28 |
User | Count |
---|---|
112 | |
81 | |
66 | |
54 | |
43 |